Question Locked

How to reference a cell in Excel with an embedded Word Doc

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an embedded word document in an excel file. i want, but do not know how to reference cells in word so that when i change the cells the embedded document auto updates.

for a graphical representation
http://www.ppcbio.com/files/embed.jpg

3 replies

by larryd4

I have never heard of a scenario your proposing. But I do know that Word creates references in its tables just like Excel. So the table in the word doc that you have embedded in excel has an "A1" location. Just as the excel sheet that you have embedded the document in has an A1.

That issue alone my cause a problem referencing the table thats embedded in the word doc.

But then again I never actually tried to reference a cell, in a table, in a word doc, embedded in an excel spreadsheet.

by larryd4

Just tried to reference a cell, in a table, that is embedded in an excel spreadsheet and I could not.

I couldn't even find doumentation on how.

My brain is already thinking you could probably do this with VB coding. But it will probably to much work for the result.

This discussion is closed to new replies.