[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Embedded Word files can't be saved

Posted on 2011-10-31
5
Medium Priority
?
283 Views
Last Modified: 2012-06-21
Hi,
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?
Thanks.


0
Comment
Question by:ewarman
  • 2
3 Comments
 
LVL 17

Expert Comment

by:Spike99
ID: 37057983
Instead of embedding the file, I would put a link to the file: is that possible?
0
 

Author Comment

by:ewarman
ID: 37078296
These files have already been set up. We've been using them for years. I don't think it would be practical to start relinking all the files.
0
 

Accepted Solution

by:
ewarman earned 0 total points
ID: 37332069
I was finally able to pinpoint the problem.
It seems when you open an embedded Word document, if you save it numerous times without saving the Excel file as well it will freeze.
I have  tested this a number of times by just opening an embedded Word file and clicking save about 10 times or so (depending on the size of the Word file). Eventually it will freeze.
The solution seems to be to either make sure to save the Excel file as well or to save the Excel file as an .xlsx file instead of .xls.
The problem does not seem to happen with the newer file format.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question