Katie has attended:
Excel Advanced course
Links to several supporting worksheets
If I have one spreadsheet (dependent spreadsheet) which links to several different supporting worksheets, how can I be sure that the dependent spreadsheet automatically updates when I make a change to the supporting worksheet?
RE: links to several supporting worksheets
Hi Katie
Thank you for your question, and apologies for the delay in response.
There will be two ways that links can be updated:
1. If both spreadsheets are open at the same time, the changes/updates should be reflected immediately.
2. If the linked spreadsheet is closed while you are making changes to the supporting spreadsheets, you should get a message next time you open the linked spreadsheet asking you if you wish to update the links.
I hope this helps.
Amanda