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.
|