Solved

Unable to edit embedded spreadsheets in Word 2007

Posted on 2011-03-25
6
807 Views
Last Modified: 2012-06-21
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.

http://support.microsoft.com/kb/275944 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.
0
Comment
Question by:QBUser
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 23

Expert Comment

by:redrumkev
ID: 35334158
QBUser,

How are you doing?

Can you post an example of this so I test.

Also, have you thought about putting the records into Access via Infopath (or Word)? Access can handle the data from multiple users and then a simple query would show all the input for any range (date, month, by each user, by response type, etc,...). Not sure when you say "merges all the answers into one file" what is taking place in this step.

Not trying to suggest that you just abandon your setup, but some other solutions might provide not only a more robust solution but provide you with additional options.

Hope this helps,
Kevin
0
 

Author Comment

by:QBUser
ID: 35336002
Unfortunately I can't post the documents or even post copies stripped of meaningful text.

I haven't found any solutions and we are now looking into alternative methods for creating the documents.

0
 
LVL 23

Expert Comment

by:redrumkev
ID: 35337568
QBUser,

Without an example, I won't be able to provide a sound solution, sorry.

Kevin
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Accepted Solution

by:
QBUser earned 0 total points
ID: 35833013
It appears to be caused by one of our many Word addins, or perhaps some combination of them.  Once we disable those, it works just fine.  Disabling them isn't an option of course, but at least we know of workarounds.
0
 

Author Comment

by:QBUser
ID: 35833028
Ok.
0
 

Author Closing Comment

by:QBUser
ID: 35872695
We know what causes the problem, but not the specific add-in, and we don't know why it or they are a problem.
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

When creating Microsoft Word-based forms there may be a need to have a form field repeated throughout the whole document. For instance, with a company name, you may want this information repeated automatically throughout the document rather than man…
Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

726 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