noob4excel
New Member
- Joined
- Aug 25, 2011
- Messages
- 1
i have a xlsm file,
ThirteenBlock .xlsm
it has 13 sheets ,6 which get data from the server corresponding to a project number entered in them,and they perform calculations,pass it onto next 6 corresponding sheets,and there is a total summary sheet at the beginning.
For a particular scenario ,this sheet got 11 project numbers,so in the summary ,6 projects got data from the server and filled up the summary tables and 5 were listed getting data from some source ,i have no clue about
it shows something like
C:\Users\myname\Desktop\[Thirteenblock additional .xls]Thirdsheet 3'!$J$43
It seems that there is a xls file somewhere ,from which this files get that additional data for rest 5 projects, and that .xls file seems to exist at the same place the original .xlsm,if i change the folder of the .xlsm
even the above path shows the new folder change
where is this xls file coming from?
Thanks in advance
ThirteenBlock .xlsm
it has 13 sheets ,6 which get data from the server corresponding to a project number entered in them,and they perform calculations,pass it onto next 6 corresponding sheets,and there is a total summary sheet at the beginning.
For a particular scenario ,this sheet got 11 project numbers,so in the summary ,6 projects got data from the server and filled up the summary tables and 5 were listed getting data from some source ,i have no clue about
it shows something like
C:\Users\myname\Desktop\[Thirteenblock additional .xls]Thirdsheet 3'!$J$43
It seems that there is a xls file somewhere ,from which this files get that additional data for rest 5 projects, and that .xls file seems to exist at the same place the original .xlsm,if i change the folder of the .xlsm
even the above path shows the new folder change
where is this xls file coming from?
Thanks in advance
