4

When you have 2 Excel spreadsheets embedded in a Word document, is it possible to one reference a cell value of the other one?

  • 1
    As far as I know, no. They are separate OLE objects and don't know about each other, or in fact that they're even embedded in a Word document in the first place. – user3463 Nov 21 '10 at 20:16
  • @Randolph but is there any alternative? can I use a single spreadsheet and show parts/views of it in diferent sections of my word document? – Jader Dias Nov 21 '10 at 20:23
  • I don't know. I'm not sure what you're trying to achieve, so perhaps your approach needs a review? – user3463 Nov 21 '10 at 20:26
  • @Randolph I have multiple tables in my document. But when I change a value in the first one, this change should propagate through all tables that reference that value – Jader Dias Nov 21 '10 at 20:53
3

I was able to do this today in XL 2010 and I'm sure it's similar in earlier versions. Create two worksheet objects in Word. Then right-click on each of them and choose Spreadsheet Object>Open. With both open, link from one to the other, save them and close each. The links then update within Word.

  • I've tried this, and while it appears to work, quite often the references are replaced with a "REF#" error. Is there some trick to this like naming the embeddings or something? – Fowl Jan 19 '12 at 0:48
  • Unfortunately you can only open one Excel object at a time in Word 2013. – Roald Apr 10 at 9:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.