Answered by:

Power Pivot disables my ability to save in Excel.

Question

After I install and open PowerPivot I loose the ability to save (and save as) in Excel. I uninstall PowerPivot and I am able to save files. When I reinstall PowerPivot I can save before I launch PowerPivot. Once I launch PowerPivot I again
loose the ability to save (and save as) the file.

All replies

The PowerPivot window is separte from the workbook itself (though they are both connected and communicate with each other). From the PowerPivot window, there is no option to save; however, after you open the PowerPivot window you can always flip
back to the Excel workbook and you can save from there

I can confirm this behavior. I reinstalled windows thinking it would help, it did not.

However, for me, I can save just fine until I actually start using a powerpivot embedded workbook. It still saves my documents in the backup location. The only other Add-Ins I am using are OSIsoft add-ins.

I can confirm this behavior. I reinstalled windows thinking it would help, it did not.

However, for me, I can save just fine until I actually start using a powerpivot embedded workbook. It still saves my documents in the backup location. The only other Add-Ins I am using are OSIsoft add-ins.

More info:

HP ProBook 6455b

Windows 7 x64 Enterprise V 6.1 (Build 7600)

Office 2010 x32 :: 14.0.5128.5000

PowerPivot 10.50.1747.0

Hi. I'm the product manager for PI DataLink.

Unfortunately there are two underlying bugs in Microsoft's PowerPivot add-in that cause these interactions with other 3rd party add-ins. We have escalated to Microsoft and are awaiting a hotfix for each issue. We have reproduced the problem with a barebones
generic add-in. Unfortunately for everyone, Microsoft is very slow at fixing problems. We've been on these core issues for 6+ months now.

In the meantime there are a couple workarounds. When using PowerPivot, always create a new workbook and work with Book2. This seems to alleviate the issue. You can also manually activate both PI DataLink and PowerPivot after loading Excel.

For any customers using OSIsoft products, please contact OSIsoft techsupport
support@osisoft.com for the latest information. When we receive a hotfix (which may be private-only) from Microsoft we will provide it to our customers as soon as possible.

Hi I also have a problem saving my powerpivot. I wonder if this is the same issue as this thread. I am using Windows 7 64 bit and Office 2010 32 bit. Here is my error message. I am new to PowerPivot. Please advice!

Errors were detected while saving 'C:\Users\sgg04929\Downloads\PowerPivotTutorial\test.xlsx'. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file,
click Cancel.

I am having the same problem. To avoid losing the work I've done when save and save-as will not work, I have found that I can go to "File/Save and Send/Save to SharePoint, and this will open something that looks very similar to the save-as box, and
allow me to save it whereever I like (not just to SharePoint).

However, I am having dificulty on top of this, in that while the data is preserved, I lose some of the ability to work with it (data not available in PowerPivot field list, and although it is in the Pivot Table field list, it will not let me put any new
objects in the values section of the pivot table - but this seems like a separate issue).

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.