98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Links to several supporting worksheets
Links to several supporting worksheets
Resolved · Low Priority · Version Standard
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Missing Field handleIf your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked. |