Update Link Automatically (does not work)
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?
|