K
Ken Ent
I have a workbook with multiple sheets, eight of which
have 600 cells with links to 6 other workbooks.
(3600/sheet) and 2 of which have 600 links to one other
workbook (600/sheet). This gives me a total of 33,600
links. I am having to move these workbooks to a new
location on the company network. While I can do a S&R on
the portion of the file path that in the link formula, the
program wants to update each and every link in each and
every cell of each and every sheet. Each time it tries to
do this, I have to click "Cancel" when it asks me to
select the file I want to update from. I have reviewed
the links box, but the option for manual update is greyed
out and cannot be selected. Does anyone know of a way to
change these links without having to press a cancel button
33,600 times?
If I move the files to the new location and then open up
all files at the same time and save them back into the new
locations - would that automatically update the links?
have 600 cells with links to 6 other workbooks.
(3600/sheet) and 2 of which have 600 links to one other
workbook (600/sheet). This gives me a total of 33,600
links. I am having to move these workbooks to a new
location on the company network. While I can do a S&R on
the portion of the file path that in the link formula, the
program wants to update each and every link in each and
every cell of each and every sheet. Each time it tries to
do this, I have to click "Cancel" when it asks me to
select the file I want to update from. I have reviewed
the links box, but the option for manual update is greyed
out and cannot be selected. Does anyone know of a way to
change these links without having to press a cancel button
33,600 times?
If I move the files to the new location and then open up
all files at the same time and save them back into the new
locations - would that automatically update the links?