Linking Embedded Excel Worksheets within Word

[nik]

I have multiple Excel worksheets embedded within a Word document. Some of
these worksheets should have cells linked to each other in order to properly
calculate formulas. Is there a way to link one cell in one of the worksheets
to the cells in another worksheet?

 

[Carol]

You can automatically link the contents of one area to that of another
location -- be the location in the same spreadsheet, a different sheet or
even a different spreadsheet entirely. When cells are linked, when the data
is changed in the original cell, the linked cell will be changed
automatically.

Select the information that you want to have linked, by
clicking-and-dragging over the cells;
Click Edit --> Copy
Move to the location to which you want this information linked -- a
different location in the same or another spreadsheet;
Press Edit --> Paste Special
In the Paste special dialog box (as shown in figure 1 above), press Paste
Link --> OK

 

[mmatz]

Yes, in one excel spreadsheet type = then click on the other workbook, click

 

[macropod]

Hi Nik,

To link data across multiple worksheets embedded in a Word document:
.. Open the 'source' worksheet by double-clicking on it
.. Select the source cells the 'target' embedded sheet is to link to
.. Copy the selected cells
.. Open the 'target' worksheet by double-clicking on it
.. Select the upper-left 'target' cell.
.. Select Edit|Paste Special
.. Choose 'Paste Link' and 'Microsoft Excel # Format'
.. Click OK

Cheers

 

[Cindy M -WordMVP-]

Hi Macropod,

Except that, in my experience, the links are lost as soon as the
document is closed. Are you seeing something different?

I've only ever been able to get anything like this by using automation
on the embedded objects to carry over the data.

To link data across multiple worksheets embedded in a Word document:
.. Open the 'source' worksheet by double-clicking on it
.. Select the source cells the 'target' embedded sheet is to link to
.. Copy the selected cells
.. Open the 'target' worksheet by double-clicking on it
.. Select the upper-left 'target' cell.
.. Select Edit|Paste Special
.. Choose 'Paste Link' and 'Microsoft Excel # Format'
.. Click OK

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail

 

[macropod]

Hi Cindy,

Provided the document you're working in has been saved before you start
inserting the links, everything should be fine.

Cheers