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