Update Link Automatically (does not work)

G

Guest

I am using Office 2007.

If I have a Word document and an Excel document, I like to "link" a portion
of the Excel spreadsheet to the Word document (very simple process) by:

1) highlight the cells I want to link in my Excel spreadsheet, right-click
and "Copy"
2) go to the Word document and click on the line where I want to insert it
3) in my Word document pull-down my options under the "Paste" icon located
in the Home tab
5) select "Paste Special..."
6) select "Paste Link > Microsoft Office Excel Worksheet Object" then OK

It is nice to see a easily manageable table, and being able to update it by
doing a right-click on the table and selecting "Update Link" when I know I
have modified the Excel spreadsheet.

P R O B L E M:

Why the Word document does not automatically updates when I modified the
Excel spreadsheet?
 
C

CyberTaz

If you have both the Workbook & the doc open at the same time the link
*should* update automatically as you make changes in the sheet. Otherwise
(if the workbook isn't open) the link only updates automatically when you
open the doc. It scans the source at that time, but it doesn't continuously
monitor the XL file. Further updates have to be made manually.
 

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