Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Denise C Denise C is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Beth Melton Beth Melton is offline
external usenet poster
 
Posts: 298
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Denise C Denise C is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Detach or change SQL data source for Word template, and other Qs SJMac Mailmerge 6 July 27th 06 10:12 AM
I am having difficulty with deleting headers and footers LHD New Users 5 July 24th 06 01:44 AM
Format Fractions in Mail Merge. John McGhie [MVP - Word and Word Macintosh] Mailmerge 4 March 22nd 06 08:55 AM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 09:02 AM


All times are GMT +1. The time now is 02:51 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"