Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating embedded links in Excel
Hello there,
i was wondering if anyone had to deal with this scenario earlier and how did they go about resolving it. We have our Finance department that had about 800 or so Excel files. There are links in these files to other Excel files. The links are of the format S:\Department\Budget\2009.xls. There is a new project happening in the company to change the folder structure of the drive that houses all these files. This would entail that the link be changed to S:\Finance\Department\Budget\2009.xls. Considering the number of files involved as well as the possibility that there might be quite a few links in each file, is there a way to achieve the change in a automatic/programatic fashion rather than a manual one in which every file and every link has to be updated manually. Any help would be greatly appreciated. Regards |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating embedded links in Excel
If any one has a solution for RC I'd love to know the answer as well.
I am in the exact same prediament. "RC" wrote: Hello there, i was wondering if anyone had to deal with this scenario earlier and how did they go about resolving it. We have our Finance department that had about 800 or so Excel files. There are links in these files to other Excel files. The links are of the format S:\Department\Budget\2009.xls. There is a new project happening in the company to change the folder structure of the drive that houses all these files. This would entail that the link be changed to S:\Finance\Department\Budget\2009.xls. Considering the number of files involved as well as the possibility that there might be quite a few links in each file, is there a way to achieve the change in a automatic/programatic fashion rather than a manual one in which every file and every link has to be updated manually. Any help would be greatly appreciated. Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem in updating the Powerpoint Embedded Chart with Excel figur | Charts and Charting in Excel | |||
Updating Links on Excel | Excel Discussion (Misc queries) | |||
updating links in Excel | Excel Discussion (Misc queries) | |||
Updating Links to Other Excel Files | Excel Worksheet Functions | |||
not updating links in excel 2003 | Excel Worksheet Functions |