gsfc
asked on
Re-establishing Excel 2007 Links when the file is moved
We have created a network directory, below which are 3 sub-directories. Below these directories are numerous Excel 2007 spreadsheets. These are linked to an "overall" spreadsheet. Due to network inherited right issues, we need to adjust the directory structure of the network directory, thus changing the path file name of the Excel documents. Is there a way to automatically re-establish the links properly in the overall spreadsheet?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER