You are currently offline, waiting for your internet to reconnect

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

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: 06/12/2010 07:59:00 - Revision: 1.0

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

  • KB2021065
Feedback
/ms.js">