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... 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.
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.