| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update links in multiple workbooks simultaneously
I have about 80 different workbooks all linked to the same data in one source
file, and a second "summary" workbook that's supposed to summarize the results of the 80 workbooks. I'd like to change the data in the source file, then open the "summary" file and have all the changes pushed through and updated in each of the 80 workbooks. But, how can I do that without having to open each one, choose "update links," and save the changes, 80 times over & over? Any suggestions will be much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
| links in multiple workbooks | Excel Discussion (Misc queries) | |||
| Links auto update on some workbooks but not others | Excel Worksheet Functions | |||
| How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions | |||
| Can you update links between workbooks without them both open? | Excel Discussion (Misc queries) | |||
Threaded Mode
