You are currently offline, waiting for your internet to reconnect

PowerPoint Cannot Save File with PowerPivot add-in active in Excel

Symptoms

Consider the following scenario. You install the PowerPivot add-in for Excel 2010. You then create a new workbook in Excel, and copy this workbook to a new presentation in PowerPoint and save the presentation. You then edit the Excel workbook inside the presentation and add a new slide. When you attempt to save the file under these conditions the following error message will be generated:

“PowerPoint was unable to open or save this document. Please ensure that you have access privileges to read or write the document and that it is not encrypted”

Cause
This is a known issue when the PowerPivot add-in is enabled within Excel.
Resolution

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756  How to back up and restore the registry in Windows

To resolve this problem, disable the PowerPivot add-in in the Excel 2010 workbook before you embed it in the PowerPoint presentation. To disable the PowerPivot add-in using the Excel interface:

  1. In Excel, click Options on the File menu.
  2. In the Options dialog box, click Add-Ins.
  3. In the Manage drop-down control, select COM Add-Ins and then click Go.
  4. Click to clear the option for the PowerPivot for Excel add-in.
  5. Click OK.

To disable the PowerPivot add-in using the Registry Editor:

  1. Close PowerPoint if it is running.
  2. On the Start menu, click Run.
  3. Type regedit, and then press Enter.
  4. Select the following key in the registry.

    HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Microsoft.AnalysisServices.Modeler.FieldList

  5. Right click the LoadBehavior value and click Modify.
  6. Change the value from 3 to 0 and then click OK.
  7. Exit Registry Editor.
More Information

A similar issue exists for Word 2010. For more information, see http://support.microsoft.com/kb/2021065

For more information on the PowerPivot addin, see http://office.microsoft.com/en-us/excel-help/powerpivot-add-in-HA101811050.aspx

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2776957 - Last Review: 04/08/2013 21:28:00 - Revision: 9.0

Microsoft PowerPoint 2010

  • KB2776957
Feedback
e="display:none;" onerror="var m=document.createElement('meta');m.name='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?">