Excel 2007 charts not updating automatically in Word doc

New Daddy
4StarLounger
Posts: 437
Joined: 05 Nov 2012, 20:02

Excel 2007 charts not updating automatically in Word doc

Post by New Daddy »

[Excel 2007 & Word 2003]

I've imported Excel charts into a Word document in the past by using paste special as object. In the past, when I edited the Excel spreadsheet, the results would be reflected automatically. I thought that was the beauty of embedding another office object. But in my current Excel 2007 & Word 2003 combination, the embedded Excel charts will not update! I have to delete them and re-import using paste special. What gives?

User avatar
HansV
Administrator
Posts: 78241
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel 2007 charts not updating automatically in Word doc

Post by HansV »

Did you select the option "Paste link"?
S0722.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

New Daddy
4StarLounger
Posts: 437
Joined: 05 Nov 2012, 20:02

Re: Excel 2007 charts not updating automatically in Word doc

Post by New Daddy »

HansV wrote:Did you select the option "Paste link"?
S0722.png
Oops.. I went "Paste".. Thanks!