MARKEGANDERSON
Active Member
- Joined
- Apr 7, 2007
- Messages
- 264
Hello All,
I have 7 diff. spreadsheets in one folder, all are Identical but name, A,b,C,etc
I also have another Spreadsheet called "Roll up"...
so for the "A" section of the Roll up, it is linked to the "A" spreadsheet.
After manually linking the A section(in the roll up) to the "A" spreadsheet, now I want to do the same for the B section(in the roll up) to the "B" Spreadsheet...
Now the easiest way I know was to do a find and replace "A.xl" with the "B.xl" and that should work...
Whenever I try that, the "update value prompt comes up, for each and every cell I am trying to do...
I did this before with no hiccups, i cant figure out why it is doing this...Please help!!!!
I have 7 diff. spreadsheets in one folder, all are Identical but name, A,b,C,etc
I also have another Spreadsheet called "Roll up"...
so for the "A" section of the Roll up, it is linked to the "A" spreadsheet.
After manually linking the A section(in the roll up) to the "A" spreadsheet, now I want to do the same for the B section(in the roll up) to the "B" Spreadsheet...
Now the easiest way I know was to do a find and replace "A.xl" with the "B.xl" and that should work...
Whenever I try that, the "update value prompt comes up, for each and every cell I am trying to do...
I did this before with no hiccups, i cant figure out why it is doing this...Please help!!!!