Embeded Excel

[Dan]

I can embed multiple Excel worksheets into a Word (2003) doc. How do I get
the sheets in Word to communicate with each other as if they were normal
separate workbooks? and syncronize?

 

[macropod]

Hi Dan,

You can link the data by copying from the source worksheet, opening the target worksheet, and using Edit|Paste Special|Paste Link.
No vba required. This is best done after you've saved the document for the first time.

Cheers