We are having a problem with modifying embedded spreadsheets in a Word document. The documents are being edited in Word 2007 but are in Word 2003 format. (It doesn't make any difference if we convert the documents to 2007 format - the same thing still happens).
The document is a form that is filled in by users. The data is collected by a macro which then merges the answers into a new file. We don't have this problem UNTIL we run the macro (but not running it is not an option).
It's after this process that the problem occurs. When you double-click to edit the spreadsheets, you get a series of errors.
The steps are:
1. Double-click the embedded spreadsheet.
2. Excel is opened automatically.
3. The message reads "Microsoft Office Word - Microsoft Office Word can't start the application required to open this object. An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now?"
4. If you answer yes, Office configuration runs.
5. You're prompted to restart. But even after restarting, the error just keeps coming back. If you answer no at this point, the next thing that occurs is that the installer starts, but if fails to complete and we get this message: "Microsoft Office Word - The program used to create this object is Excel. That program is not installed on your computer. To edit this object, you must install a program that can open the object."
We have already installed pretty much every available option for Office 2007. We do have Excel installed.
The problem is also somewhat intermittent; sometimes you can get one of the spreadsheets to work but you can count on it failing at least once.
describes this problem but I don't think it's quite on target. I don't think we have objects embedded within objects. I'm not sure how to verify that. Is the problem that we have more than one embedded spreadsheet? There are 3-4 in this document.
Having Excel already open doesn't help.
I also tried disabling all add-ins but that didn't work either.