Embeded Excel

D

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?
 
M

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
 
Top