Is there a limit to link excel to other excels?
I have 1 master excel and about 50 small excels. the master is linked to the 50 excels.
each cell in the master is link to one cell in one of the small excel.
I notice that when we a certain amount of linked data, link does not work anymore?
even though i update the cell in one small excel, the master is not update. a typical link is as follows:
='G:\ExcelFiles\[_X.BOW_ 22 Sep 10, 1011.xls]Sheet1'!F2
where [_X.BOW_ 22 Sep 10, 1011.xls] is one of the 50 small excels
F2 is variable too...
How do i solve that? make sure the master update all links?
I have 1 master excel and about 50 small excels. the master is linked to the 50 excels.
each cell in the master is link to one cell in one of the small excel.
I notice that when we a certain amount of linked data, link does not work anymore?
even though i update the cell in one small excel, the master is not update. a typical link is as follows:
='G:\ExcelFiles\[_X.BOW_ 22 Sep 10, 1011.xls]Sheet1'!F2
where [_X.BOW_ 22 Sep 10, 1011.xls] is one of the 50 small excels
F2 is variable too...
How do i solve that? make sure the master update all links?
