MS Office and Open Office OLE

Factual Questions
1

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

2

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.