Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update source link in MANY files
I have about 85 excel files that point to 1 single source sheet. However,
each file may point to a different cell in the source, and the destination cell is not always the same (ie A2) I need to move the source to a different file path on the file server. Is there an easier way to update all 85 file links, without having to open each one, and re-point to the source file? I have thought about a macro, however, as I said, each file may point to a different cell, and the destination cell is not always the same. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link a Master Template Excel file to different excel source files | Excel Worksheet Functions | |||
Can I find what files link into a source file in Excel? | Excel Worksheet Functions | |||
How to update destination file with source files closed? | Excel Discussion (Misc queries) | |||
2 files, mass update comments between files | Excel Worksheet Functions | |||
2003 update link when Source open | Excel Worksheet Functions |