Linking Embedded Excel Worksheets within Word

N

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

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
 
M

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
 
C

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 :)
 
M

macropod

Hi Cindy,

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

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top