Cindy
Tue Nov 07 08:08:02 CST 2006
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 :-)