# MS Office and Open Office OLE
**URL:** https://boards.straightdope.com/t/ms-office-and-open-office-ole/501865
**Category:** Factual Questions
**Created:** [July 4, 2009, 2:56am UTC](https://boards.straightdope.com/t/ms-office-and-open-office-ole/501865 "2009-07-04T02:56:24Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@rbroome](https://boards.straightdope.com/u/rbroome)
#### Post date: [July 4, 2009, 2:56am UTC](https://boards.straightdope.com/t/ms-office-and-open-office-ole/501865/1 "2009-07-04T02:56:24Z")
I need to create a Word document that has in it some tables that are created and maintained in Excel. I can make this happen in Word/Excel. Create the table in Excel, insert into Word, make changes in Excel and see the changes in Word.
I also need that Word doc to correctly work in Open Office 3.
I can create a table in Excel, open the word doc in OO and insert the table from Excel into the word doc. two problems-MS Word won’t see it and it can’t be updated in OO.
Has anyone done this? It is a pretty basic functionality that seems to be supported in OO, but I can’t make all the pieces work the way I need to.
Thanks
---
### Author:  [@rbroome](https://boards.straightdope.com/u/rbroome)
#### Post date: [July 5, 2009, 7:12pm UTC](https://boards.straightdope.com/t/ms-office-and-open-office-ole/501865/2 "2009-07-05T19:12:36Z")
I found that I am unable to even do what I need to do inside MS Office.
I have a single spreadsheet with several worksheets. I need to display each worksheet in a separate place in my Word document. Linking by file doesn’t seem to be dynamic-once inserted the data in the Word document doesn’t update, and linking by object updates but I can’t control what worksheet gets displayed.
Very frustrating.