Hey I have a problem again =( such an Excel noob I am!!!
Basically there are about 100 roster workbooks. They are for individual store to use.
So I've created a new sheet using one of the store's file as an example.
The sheet is fairly complicated with reference to other sheets INSIDE individual workbooks.
Then I copied the skeleton of the sheet with only the pointers to the sheets that is used, by replacing the file name reference with nothing, to another workbook that I use to roll out the sheets to the other stores.
My problem is now that when I copied over the sheet to the workbook, the cell does not refresh by itself, so the value of the sheets is still #REF. But when I go on that cell, press F2 then enter, the value is shown nicely.
I'm just wondering is there any way I can do the above without having to do that for 34 rows x IM columns!!
Sorry if I'm not making any sense, but any help is greatly appreciated!!! =D
Basically there are about 100 roster workbooks. They are for individual store to use.
So I've created a new sheet using one of the store's file as an example.
The sheet is fairly complicated with reference to other sheets INSIDE individual workbooks.
Then I copied the skeleton of the sheet with only the pointers to the sheets that is used, by replacing the file name reference with nothing, to another workbook that I use to roll out the sheets to the other stores.
My problem is now that when I copied over the sheet to the workbook, the cell does not refresh by itself, so the value of the sheets is still #REF. But when I go on that cell, press F2 then enter, the value is shown nicely.
I'm just wondering is there any way I can do the above without having to do that for 34 rows x IM columns!!
Sorry if I'm not making any sense, but any help is greatly appreciated!!! =D
