Power Pivot disables my ability to save in Excel.

Question

Hi, 

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.  

Any suggestions?  

-Josh

Answer 1

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

---

Javier Guillen
MCTS / MCITP SQL Server 2008 BI
http://www.msbicentral.com/Blogs/JavierGuillen.aspx

Answer 2

Thanks for the response, but its not an issue of attempting to save through the PowerPivot window.

The problem seems to be isolated to the installation of PowerPivot.

Without PowerPivot installed the save (and save as) function in Excel 2010 works as it should. 

When I install PowerPivot I am able to save a file initially, but subsequent attempts to save don't work.

When I make changes and go to File=> Save (or Save As) Excel takes me back to the Home tab and does not save changes. 

This problem occurs when I launch Excel in regular and safe mode (PowerPivot add-in disabled, but installed).

 

 

 

 

Answer 3

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

Answer 4

I am having the same issue and have had to uninstall PowerPivot - has anyone been able to find a solution?

Answer 5

Still no resolution for me.  What brand/model of machine are you using?  What version of windows and what version of office?  I am trying to find a common thread.

Answer 6

Still no resolution here.   I'd like to see a fix = currently the product is useless.  

Here's my info: 

Dell Optiplex 380

Windows 7 x32 Professional SP1

Office 2010 x32 :: 14.0.5128.5000

PowerPivot 10.50.1747.0

---

Josh

Answer 7

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 [e-mail] 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.

 

Answer 8

Hi Matt.

 

We're hitting this problem too.  Any update on the hotfix?

 

Thanks,

josh

Answer 9

I recently came across this issue as well, a hotfix was provided by Microsoft last June:

http://support.microsoft.com/kb/2544025

Answer 10

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.

Thanks for any help.