I have a number of Excel files that link to other spreadsheets. The files are
located in a variety of folders.
Is there a way to relocate all files into the one folder and still maintain
all the links. I am hoping that by placing all files in one folder that Excel
will look in that folder first to find any linked files. I don't want to have
to open all files to get this to work or have to re-link to the new locations.
regards
PeterH