Preserving links after relocating files on PC

P

PeterH

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
 
M

macropod

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]


| 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio to Excel 0
Update several ppt documents from a single excel file 0
Embed the same Excel multiple times 0
Automation of scanned file storage based on content 0
Preserving links after relocating worksheet files 0
Synchronization problems while moving folders to new email 1
Converting URLs in comments to Markdown-formatted links 2
Re-title multiple MS Project .mpp files at once 0

Top