This solution is for the following errors when you try to edit an embedded Microsoft Excel file in the Word Document. I’ve experienced this problem on Office 2007 and Office 2010.
For e.g. If you have an embedded Excel sheet inside a Word Document like shown below, and want to edit. When you double click on it, you get any of the following errors or all of it. Microsoft Word simply won’t let you edit it. It was a huge pain in the ass and took me many days to find a solution. It sometimes worked on some of my user’s computer. I read through many forums, (forget about what support.microsoft.com says, it won’t work!) and found many so called “solutions”, but none worked for me. Some of the people suggested converting the table/ Excel sheet as explained in Error no 3. It throws another error.
PROBLEM: Microsoft Word not allowing users to edit an embedded Excel file as shown below.
ERRORS YOU MAY GET
Error 1:
Error 2:
Error 3: If you try to follow this solution:
1. Right-clicking on the Excel object
2. Click Worksheet Object -> Convert…
3. Choose Microsoft Office Excel Binary Worksheet
4. Click OK
SOLUTION
Basically there is no solution yet for this issue, but there is a workaround which is explained below.
Step 1: Copy the Excel sheet from the Word (Click on it, and CTRL +C)
Step 2: Open Outlook and compose new message
Step 3: Paste the copied Excel sheet into the Outlook New message window
Step 4: Double click on the Excel sheet you just pasted in Outlook and it may prompt you:
Step 5: Click Yes you will be able to edit it.
Step 6: Once complete the editing, copy the same and paste back into the Word Doc (Replace the old Excel sheet)
Step 7: Sit back and Relax!
Hope this saved your time.
Do you find this information useful? Share it with your friends by on Facebook, Google+, Twitter or other Social Media. You can also follow me on Twitter @sarayoo.info or Google+ or Like me on my Facebook or on my LinkedIn for more updates, technology tips and tricks, iPhone, iPad, other iOS devices tips, iOS App Deals, Blogging tips, etc. Please leave your comments in the comment section or contact me if you have any other questions.