Calculations did not find required folder

[KCK]

Hello,

I have received a number of files that are all linked together via
calculations. The files were origianlly unzipped onto someones C:\ drive.
They have copied them onto a shared R:\ drive for me to access but the
calculations all continue to point to the original unzipped folder which
cannot be found. When I open each file it asks if I want to update the file.
I click YES and then it indicates the links can not be found. There are 9
files and tons of worksheets and calculations so doing the changes manually
is a huge task.

Is there an easy way to fix this problem? Perhaps rezip from the original
unzipped folder and then unzip onto the shared folder?

Thanks,
Kerry

 

[Kevin B]

If you're using a release of Excel prior to 2007, open the file that has the
links and click EDIT on the menu and select LINKS from the drop down menu.
Then use the CHANGE SOURCE command button to remap the link.

In Excel 2007, click the DATA tab on the ribbon and click EDIT LINKS. Then
use the CHANGE SOURCE command button to remap the link.