PowerPivot: You cannot edit embedded Excel workbooks in Word when PowerPivot is enabled

Article translations Article translations
Article ID: 2021065 - View products that this article applies to.
Expand all | Collapse all

Symptoms

You embed a Microsoft Office Excel 2010 workbook in a Microsoft Office Word document. Additionally, the PowerPivot add-in is enabled for the workbook. When you try to activate the workbook for editing in Office Word, you recieve the following error message:

The program used to create this object is Excel. That program is either not installed on your computer or it is not responding. To edit this object, install Excel or ensure that any dialog boxes in Excel are closed.

Cause

Status: Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Resolution

To resolve this problem, disable PowerPivot in the Office Excel 2010 workbook before you embed it in an Office Word document.

More Information

Steps to reproduce the problem
  1. In Office Excel 2010, create a workbook that has PowerPivot enabled.
  2. Save this workbook, and use "TestPowerPivot.xlsx" as the name of the workbook.
  3. Create an Office Word document, and then embed the TestPowerPivot.xlsx workbook in the Office Word document.
  4. Save the Office Word document, and use "PowerPivot.docx" as the name of the document.
  5. Open the PowerPivot.docx document.
  6. Try to edit the workbook that is embedded in the document.

You expect to be able to edit the Excel workbook. However, you experience the problem that is described in the "Symptoms" section.

Note You do not receive an error message if PowerPivot is already disabled for the embedded workbook.

Properties

Article ID: 2021065 - Last Review: June 12, 2010 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
Keywords: 
KB2021065

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com