Unable to reopen an Excel sheet embedded in Word

Tablabiz Posted messages 3 Status Membre -  
 Eurielle -
Hello,
I want to clarify right away that the bug is well-known and widely discussed on forums in both English and French. It appears in several versions of Office and under various versions of Windows. Weeks of research, with the help of friends, have yielded no results. Nobody has found a solution. The responses on blogs have not resolved anything.
To reproduce the bug: open Word, write a few words, go to Insert, choose to insert an Excel sheet. In the Excel sheet opened in Word, enter a few numbers and perform an addition. Click anywhere in the Word document, the Excel sheet becomes inactive and you can continue writing in Word. So far, nothing unusual.
Now click on the Excel sheet, it becomes active again and you can modify the numbers. Click anywhere in Word and the Excel sheet becomes inactive again. Save your Word document with the Excel sheet and exit. Open the Word file you just created and click on the Excel sheet. It won’t open anymore. A bogus message informs you that the program used to create this object is Excel and that it is not installed on the computer.
What can I say, I've tried everything, the advanced options in Word and Excel, the repair of Office and Windows. To top it all off, if I open the Word document in question with Open Office's word processor, there is no issue. According to some forums, users have even changed their version of Office and still kept the same problem.
If you could help me...
Best regards.

5 réponses

Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
Hello.

Don't blame Word or Excel: It's you who didn't read everything...
"A bogus message tells you that the program used to create this object is Excel and that it is not installed on the computer". This is incorrect: The message, which is not bogus at all, but of the utmost importance, precisely says:
"The program used to create this object is Excel. This program is not installed on your computer or it is not responding. To modify this object, you need to install Excel or check that the Excel dialog boxes are closed".
If, while you are working on the Word document, there is an Excel workbook open with a task in progress,
like an entry not yet validated in a cell for example
, that blocks access!
Make sure you don’t have any pending validation entries, or more radically, close the other Excel workbooks, and everything will work perfectly!
I have checked...

If you could kindly indicate to me all the blogs and forums where your friends and you found nothing, I would be happy to repeat my explanations to them.

Sincerely.

--
Retirement is nice! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)
-1
Eurielle
 
Mr. PENTIER,

A thousand thanks! You have provided the only relevant answer that has saved me after several days of searching for a solution to my problem!!
Bravo and thank you!!!!
-2