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

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.1 secs.