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

Hi Peter,

I think you've just discounted the only two ways of doing this. You could, of course automate the process with a macro.

Cheers

--
macropod
[MVP - Microsoft Word]


"PeterH" wrote in message ...
| 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