Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Moving xls files that have links?? | Links and Linking in Excel | |||
Creating Links to files in a shared directory | Excel Discussion (Misc queries) | |||
Excel 2003: Temporarily "turning off" links to external files... | Excel Discussion (Misc queries) | |||
links to same files in different folders | Excel Worksheet Functions | |||
Links to other files | Excel Discussion (Misc queries) |