Referencing cells in embedded worksheets in Word

werhand

New Member
Joined
Jun 9, 2009
Messages
5
Does anybody know of a solution to be able to reference a cell in one embedded worksheet in a Word document by a different embedded worksheet in the same Word document? For example, Worksheet A has a table with a sum of a column, and later in the document Worksheet B needs that sum to perform further calculations on. I need the document to be self-contained (otherwise I would just use a linked worksheet instead of embedded worksheets).

I have attempted a solution by opening two embedded worksheets and creating a reference (creates a cell entry in Worksheet B as "='Worksheet in Filename.doc'!A1"), but the document includes numerous (more than a dozen) embedded worksheets and the generic "worksheet" creates problems when you start referencing more than one worksheet.

Any ideas would be appreciated!
 

Forum statistics

Threads
1,082,555
Messages
5,366,293
Members
400,882
Latest member
zaldy_a

Some videos you may like

This Week's Hot Topics

Top