Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Excel Data in a Word Document
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! -- Denise C |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Excel Data in a Word Document
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/p...cle.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/prev...e_archive.mspx TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Denise C" wrote in message news 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! -- Denise C |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Excel Data in a Word Document
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! -- Denise C "Beth Melton" wrote: 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/p...cle.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/prev...e_archive.mspx TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Denise C" wrote in message news 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! -- Denise C |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Excel Data in a Word Document
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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Detach or change SQL data source for Word template, and other Qs | Mailmerge | |||
I am having difficulty with deleting headers and footers | New Users | |||
Format Fractions in Mail Merge. | Mailmerge | |||
Word Field Codes in Excel data file | Mailmerge |