Embedded Excel document in Microsoft Word

Hello!

I have one very hard to solve problem for me so if anybody will be able to help me I will be very grateful!

I have an Word document where I need to place many different embedded excel objects. The only problem is, that there must be some of relationship between them (ex. make sum in table A based on data from table B or make average in table C from data in table B etc.) The problem is that they are (embedded objects) independent and do not want to work together...

I figured that maybe I could create one embedded excel and show different parts of it in different places of Word document. What do you think? If this even possible?

Maybe do you have better idea that mine?

I'm using Microsoft Office 2003 (this is company software) and everybody have the same, so I'm searching the solution for software not higher than 2003...

I will be really appreciated when somebody will help me or have better idea that mine!

Thank you and have a nice day!

Originally Posted by macropod

The simplest solution is to use an external workbook and copy/paste the required ranges into Word using the Paste Special 'Paste Link' option. That way, you don't need the Word document to be open to edit the data but, when you do, all the links will update to reflect the latest data.

Hello marcopod,

This is great! There is no possibility to do the same but embed excel inside word?

I'm trying to find solution for many users, different database's etc. so the less external files - that's better.

But overall - this is the effect that I wanted to achieve!

Thanks!