Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > Updating Excel Charts in Word Document

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Updating Excel Charts in Word Document

Reply to Message Icon

Name: maynardallie
Date: June 30, 2009 at 12:31:48 Pacific
OS: Windows XP
Product: Microsoft Office 2003
Subcategory: Microsoft Office
Comment:

charts embedded in a word document, 'pasted as
link' from excel s/s will not update when word
document is accessed; automatically or
manually. all settings in word have been
confirmed. running office 2003. any ideas as to
why this functionality is not longer available?



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: June 30, 2009 at 13:05:45 Pacific
Reply:

re: any ideas as to why this functionality is not longer available

When you say this functionality is not longer available are you implying that it used to work - in this specific document?

Does it still work in other documents?

It could be nothing more than a busted link that needs to rebuilt.


0

Response Number 2
Name: maynardallie
Date: June 30, 2009 at 13:13:27 Pacific
Reply:

that is correct, it used to work and has since stopped. regarding
the possibility of the link needing to be reestablished, we are
forced to do so anytime the chart requires updating. the chart is
deleted, updated in excel and pasted as a fresh link.


0

Response Number 3
Name: DerbyDad03
Date: June 30, 2009 at 13:36:15 Pacific
Reply:

Not sure if you answered this question:

Does the functionality still work in other documents?

New questions:

Do new charts in the same Word document work?

Does the same chart work in other Word documents?

I just trying to come up with things for you to try to possibly narrow it down to a corrupt Word doc or a corrupt Excel file or a broken application.


0

Response Number 4
Name: maynardallie
Date: June 30, 2009 at 13:42:14 Pacific
Reply:

thanks so much for your interest in this issue. i'll talk further
with the direct end user and find out additional details for you.

thanks again.


0

Response Number 5
Name: maynardallie
Date: July 2, 2009 at 08:25:00 Pacific
Reply:

went through a few tests and this is what we came to:
this problem is consistent across the board in any word
document that is linked to any of our s/s.
when a chart is pasted as a linked, excel chart object, the
link is active and updates perform as expected.
however, once you adjust the text wrapping effect (ie. behind
text, in front of text, etc.) for that chart, you lose the ability to
update the links both manually and autuomatically, requiring
the charts to be deleted, updated in excel and re-pasted.
Hopefully this will give the additional detail needed.
Thank you!


0

Related Posts

See More



Response Number 6
Name: DerbyDad03
Date: July 2, 2009 at 09:02:41 Pacific
Reply:

Sorry, I'm unable to duplicate your problem.

I copied a chart in Excel, did a PasteSpecial...Paste Link in a Word document and then used the Format Object...Layout tab to change the Behind Text, In Front Of Text, etc. settings and had no problem updating the chart afterwards.


0

Sponsored Link
Ads by Google
Reply to Message Icon



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: Updating Excel Charts in Word Document
referrencing excel cells in word www.computing.net/answers/office/referrencing-excel-cells-in-word/6651.html

Creating an index in Word XP www.computing.net/answers/office/creating-an-index-in-word-xp/5407.html

hyperlinks in Word www.computing.net/answers/office/hyperlinks-in-word/1384.html