Using Embedded Excel Worksheets in Word

Donna O. Colby

New Member
Joined
Nov 18, 2005
Messages
2
I have a Word Template I created to produce an automated manual-type document. I need to link cells from one worksheet to another... :rolleyes: I create an unsaved worksheet in Excel, select the range and Edit\Paste Special in Word where I want the workbook/worksheet to appear (there are several of these worksheets throughout the document). I then select a formula cell in the embedded worksheet and choose Edit\Paste Special\Link from a different worksheet, created the same way in Excel and embedded in the Word Template, where I need to use that formula. I then receive a #REF error.

I'm using MS Office XP, have reinstalled the application and downloaded all available patches. I can't save the workbooks and link them separately because this document is handled by many outside contacts and needs to be self-contained.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
this is only a suggestion not tested because your need are not knowm.
instead of copy paste an unsaved file why not insert saved excel spredsheet as an object in Word document. open new word document and see help
<Create a linked object or embedded object from an existing file>

extract
Click in the document where you want to place the linked object or embedded object.
On the Insert menu, click Object, and then click the Create from File tab.
In the File name box, type the name of the file you want to create a linked object or embedded object from, or click Browse to select from a list.
To create a linked object, select the Link to file check box.
 

Donna O. Colby

New Member
Joined
Nov 18, 2005
Messages
2
Don't I have to send the workbooks with the Word document when emailing it as an attachment? I need to simplify this task.
 

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
it depends upon requirements. if all the tweaking isdone only by yuu hen it is enough only to send document periodically. If the user has to tweakyou have to send both. In your case you have to save both in your hardidisk.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,536
Messages
5,572,774
Members
412,482
Latest member
arooshrana2
Top