Embedded Word files can't be saved
Posted on 2011-10-31
We have a number of Excel files that contain embedded Word documents. The Word files are embedded as an icon so that when we double-click the icon, the Word file open in Word and can be edited.
What has been happening with some of the files is that after editing when we try to close the Word file, it will not close. Nothing happens when we click the close button. (We can save it as a separate file).
At the same time if we go to Excel, the Excel file cannot be saved while the Word file is open.
The only way to close Word is to end the task Once we do that we can save excel. However the embedded Word file is corrupted and cannot be opened again. We have to reinsert the file again into Excel.
It appears that when working on the Word file, it seems to lose the connection to the Excel file.
The question is why is this happening and is there any way to prevent this?