Troubleshooting Excel in Word

[t :-)]

I've created a couple of documents with Excel spreasheets inserted in
either/or Word Table Cells or in Text Boxes. On several occassions in the
past several weeks since I've created these documents/forms, several of the
Excel Spreadsheets have appeared to have changed, on their own, to a picture.
The reason I've inserted the Excel spreadsheets into the Word Docs instead
of doing it all in Tables is because of the various formulas that can come
into play. But I need the versatility of spacing around on the page that I
can get with Word that is not available in Excel, on it's own.

First, is there a way to get these 'pictures' back to an Excel Spreadsheet.
Then, is there a way to keep this problem from continuing to happen?

Thanks.

 

[Cindy M.]

Hi =?Utf-8?B?dCA6LSk=?=,

I've created a couple of documents with Excel spreasheets inserted in
either/or Word Table Cells or in Text Boxes. On several occassions in the
past several weeks since I've created these documents/forms, several of the
Excel Spreadsheets have appeared to have changed, on their own, to a picture.
The reason I've inserted the Excel spreadsheets into the Word Docs instead
of doing it all in Tables is because of the various formulas that can come
into play. But I need the versatility of spacing around on the page that I
can get with Word that is not available in Excel, on it's own.

First, is there a way to get these 'pictures' back to an Excel Spreadsheet.
Then, is there a way to keep this problem from continuing to happen?

It's pretty certain you can't revert objects that have become unlinked from the
OLE Server (Excel, in this case) back to active OLE object. (OLE = Object
Linking and Embedding)

When this happens, it's usually due to the OLE Client (Word, in this case) being
unable to open/link the object back up to the OLE Server. If the process is
unsuccessful, Word will convert the object to a static graphic. Possible causes:

- the user unlinked the object (Ctrl+Shift+F9 when it was selected)
- automation code unlinked the object
- a third-party application is interdicting the link back to the "parent"
application

In recent years, this last has become increasingly prevalent. The Norton Office
Antivirus Plug-in is one culprit that interferes with Office applications
communicating as they were designed to do; there are others out there that have
similar effects.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail