Re-establishing Excel 2007 Links when the file is moved
Posted on 2011-02-23
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?