Link to home
Start Free TrialLog in
Avatar of stack888
stack888Flag for Canada

asked on

"the program used to create this object is excel" - cannot open embedded excel within Word 2007

Got this problem on 2 PCs but not on the 3rd.

On the problem machiese, one PC is Vista, the other is Windows 7 (the working PC is also Windows 7).

Each time I try to open an embedded Excel table within a Word 2007 document, it gives me the above error and says "The program is not installed on your Computer".

I've tried all the suggestions I can find through googling the error but no luck. Seems its a common issue.
On the working Windows 7 PC, its the same version of MS Office installed and the same Service Pack.
Anyone have any suggestions?
Many thanks
Avatar of Binh Win
Binh Win
Flag of United States of America image

Sounds like you are missing an Add-in.  Did you compare all the Excel Add-Ins between both computers and make sure the Add-Ins are loaded when Excel starts?  Could be an Add-ins corruption too.  
Try this
Right-clicking on the Excel objects.
2. Click Worksheet Object -> Convert.
3. Choose Microsoft Office Excel Binary Worksheet
4. Click OK

After it converts it to a Binary worksheet, you can then repeat the process
and choose Microsoft Office Excel Worksheet
Also found this workaround:
Open another application that could embed the excel and from which you can copy a text paragraph, e.g. Outlook => New Email, use rich text format (rft).

In outlook you can simply drop e.g. the excel sheet or any other application. Then copy the whole text and Excel icon from the email /outlook window to Word. Then you can open and edit the embedded Excel sheet as normal.

Avatar of stack888

ASKER

xtemie, thanks for the suggestions but that won't work.

The first one doesnt work - just gives an error when trying to convert to binary worksheet.

The second option isn't practical at all. We have users with very large documents, maybe 200 pages with 20 or 30 embedded excel objects. So to ask them to go through every individual object and copy and paste it into another App, e.g. outlook and then copy it all back again into Word and save and then repeat that for every document they have, just wouldnt work.

This is an odd one, Microsoft dont seem to have a fix for it and I've seen countless posts with the same problem all over the web.
could you post a sample on this?
It is quite odd that even if its such a common problem, there is no fix...
I will keep looking!
Similar problem here, with references to possible solutions, if you wanna give these a try.

http://social.msdn.microsoft.com/Forums/en/vsto/thread/74aaea5b-a14f-4b60-8683-b2c3831120e1
yeah, saw that one but there isn't really an answer in there, its just discussion on com programming.
If you google the error I get, there are lots of forums where people have posted the same problem and very little in the way of solutions offered so far that I can see. Most of the forums have the question open and people are just blaming Microsoft for it being a Windows 7 or Vista issue :P
I dont think thats quite the case as it obviously isnt affecting every PC (I have some PCs here where there is no issue at all, with the same O/S, same MS Office version installed).

I'll try and post a screenshot later when I can get access to one of the PCs with the problem.
thanks
ok, here's the screenshots...
The first is when I click anywhere on an embedded excel table.
The second shows me selecting to convert to binary (one of the suggested solutions out there on the web)
The third shows the actual error when I try to convert to binary. embedded-errors-in-word.docx
that's peculiar
are you using a network installation of office or a local one?
it was a local install of MS Office 2007, same disks used on all machines here, including those working perfectly. Hard to say what the cause it, could be some third party s/w and how it interacts with Office Add-ins.
Maybe you should try installing Office before anything else on new machines so that add ins are not messed up
ASKER CERTIFIED SOLUTION
Avatar of stack888
stack888
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
users going to use other machine to view these files as unable to resolve.
closing question.