Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
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

1 Answer 1

up vote 3 down vote accepted

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.

share|improve this answer
    
It worked! thanks –  Jader Dias Nov 26 '10 at 4:13
    
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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