View Single Post
  #2   Report Post  
Posted to microsoft.public.word.oleinterop,microsoft.public.word.vba.general,microsoft.public.excel,microsoft.public.excel.programming
JD JD is offline
external usenet poster
 
Posts: 5
Default Manipulating embeded exccel in word (Repost)

Thanks Earl

That makes sense, and seems to work when I manualy copy a chart from
the Embedded workbook and then Embed it as a linked, in another part of
the Word document.

[To summarise - I am embedding a linked chart from an already embedded
Excel worksheet that contains the data (and charts)]

Word
|
|__Embedded Excel Workbook with data sheet and several charts
|
|____Embedded, Linked Charts from above.

Now I just need to work out how to update all this automatically - the
update link doesn;t seem to "referesh" the charts.

I assume if I embed/link all my charts then these should automatically
update when the Embedded Source data sheet is changed. I am having a
few problems with this, but I will keep plugging away.

If you have any tips or hints on this let me know.

Thanks

Jason.