| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update links without opening other files
Client is using Excel 03/WinXP. She has a Summary file. She enters a value
into the Summary sheet, which then populates a cell in File A. File A then does a calculation on that value. The Summary sheet should then display that calculation. If both the Summary file and File A are open, everthing updates. However, she has the Summary file linked to about 60 other files. She was hoping this would work so that she would not have to go into all 60 files to make the changes. Calculation is set to Automatic and have tried the Update Links button in the Edit, Links dialog box but none of those work. Would there maybe be some code that would update the Summary sheet without having to open the other files? -- maryj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update workbook links without opening all workbooks | Excel Discussion (Misc queries) | |||
| User is not prompted to update links when opening spreadsheet | Excel Worksheet Functions | |||
| automatically update links without opening file | Excel Worksheet Functions | |||
| Hide prompt to automatically update links on workbook opening | Excel Programming | |||
| update links when copying files | Excel Programming | |||
Threaded Mode
