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.

I have a Word document with an Excel document embedded. I would like to show some values from the Excel in the Word document. Of course they have to get updated when the Excel changes. I know how to do this for an external Excel worksheet, but I did not find a way to do this for my embedded one. I am using Office 2010.

share|improve this question

2 Answers 2

AFAIK the only way this works is if you use .doc format, and even then it may not be completely reliable. Otherwise, the problem is that Word references the existing embedded Excel object using an ID that (a) Word changes when you save or re-open the .docx and (b) that you cannot discover using the Word Object Model. So you can't even "fix up" the references using VBA.

share|improve this answer

It doesn't always work, but once I used Tools->Insert>Object(excel)

share|improve this answer

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.