Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

links several supporting workshe

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Links to several supporting worksheets

Links to several supporting worksheets

ResolvedVersion 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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.