Linking Excel Data in a Word Document

[Guest]

I have inserted an Excel object into a Word document. When I then open the
Excel file by double-clicking on it, make a change in the Excel file, and
then go back into the Word document, the changes are not reflected in the
Word document until I right-click on the table and choose Update Link.

Everything I read (including Element K's (Microsoft approved) Level II
training manual!) says that the link should update automatically once the
change is made in the Excel file. I have checked in Links, and the
Automatically Update radio button is selected. Any ideas? Thanks!

 

[Beth Melton]

What version of Word are you using and do you have all of the patches
installed? It sounds like the link is not automatically updating due
to a Word field security patch that prevents fields such as a LINK
field from updating automatically. This article contains more on the
changes along with a link at the end you can use to download an add-in
which you can use to modify the patch behavior:
http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=120

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Office 2007 Preview Site:
http://www.microsoft.com/office/preview/default.mspx
Office 2007 Community Articles/Tutorials:
http://www.microsoft.com/office/preview/community/article_archive.mspx

TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Guest]

Hi Beth,
Version is 2002, and I'm not sure about the patches, it says Service Pack 3,
is that what you mean? Our IS department handles all that stuff, I don't
have any authority to download anything, we're not allowed, but at least I
know why it's behaving that way!

Thanks so much for your help! I'll definately check out the link!

 

[Cindy M.]

Hi Denise,

I would guess the information in the following article applies

http://support.microsoft.com?kbid=330079

I have inserted an Excel object into a Word document. When I then open the
Excel file by double-clicking on it, make a change in the Excel file, and
then go back into the Word document, the changes are not reflected in the
Word document until I right-click on the table and choose Update Link.

Everything I read (including Element K's (Microsoft approved) Level II
training manual!) says that the link should update automatically once the
change is made in the Excel file. I have checked in Links, and the
Automatically Update radio button is selected. Any ideas? Thanks!

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail