Update Link Automatically (does not work)

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top