Updating multiple worksheets within a document

C

Caro-Kann Defence

Hi there

I have a word document that has multiple links to an Excel workbook and each
link is to a different worksheet within the Excel workbook.

Is there a way that I can refresh all the tables at the same time? Do I need
to open each linked object to refresh? I see the option to update all links
when printing but if someone is viewing the document can they refresh all the
links at the same time?

Thanks!
 
D

DeanH

Ctrl+a to select the whole document, F9 to update all links within document.
This includes the external links as well as Table of Contents,
Cross-references, bookmarks, etc.
Hope this helps
DeanH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top