How do I – Uninstall PowerPivot for SharePoint 2010

Written by Cornelius J. van Dyk on . Posted in How Do I...

Given how much effort is was to get PowerPivot installed and working in the first place, you may never need this post, but just in case something goes wrong and you have to uninstall it to start over, here’s how to do that:

  1. Launch Programs and Features via Start/Control Panel/Uninstall a Program.
  2. Locate the “Microsoft SQL Server 2008 R2 (64-bit)” entry and select it with a left click.
  3. The Uninstall/Change button becomes active.  Click it.
  4. Windows may warn you that there are other users that’ll be affected.
  5. Click “Continue” to ignore the warning and proceed.
  6. The SQL Server configuration tool opens.
  7. Click “Remove”.
  8. Setup will load all the support rules.
  9. Once all rules were loaded, click “OK”.
  10. Change the “Instance to remove feature from” dropdown value to “POWERPIVOT”.
  11. Click “Next”.
  12. Ensure that “Analysis Services” and it’s sub categories under POWERPIVOT is checked.
  13. Click “Next”.
  14. Setup runs all the removal rules.
  15. Once the rules have run successfully, click “Next”.
  16. On the Ready to Remove screen, click “Remove”.
  17. Once setup has removed PowerPivot, you’ll be taken to the Complete screen.
  18. The status should indicate that the removal was successful.
  19. Click “Close”.

    If you have previously removed PowerPivot and am trying to reinstall it again, the installation may fail because the removal didn’t cleanup everything properly.

    If you install PowerPivot and go to the Solution administration page, there’s a .wsp for PowerPivot called “powerpivotfarm.wsp”.  If this solution shows an error with a message of “Some of the files failed to copy during deployment of the solution”, then the uninstaller didn’t cleanup everything successfully.


    Looking at the error above, the Microsoft.AnalysisServices.SharePoint.Integration.dll assembly didn’t get deployed to the GAC.

    If you browse to the GAC via Windows Explorer, you’ll see this:


    OK, so it is NOT there.  That’s what we expected because that’s what the error indicated.

    Ah… but wait… there’s more…

    Open a command prompt on the server.

    Now manually change directory to the GAC_MSIL folder and do it dir for that DLL.

    And what do we get?…


    It seems that the folder was not cleaned up successfully during a past uninstall.  The installer isn’t smart enough to figure out that’s the right folder to put the DLL and simply throws an error.  It wants to create the folder from scratch.

    Us the RD command to remove the offending folder and then retry your installation.  Odds are it’ll work this time.



Tags: , , ,

Trackback from your site.

Cornelius J. van Dyk

Born and raised in South Africa during the 70's I got my start in computers when a game on my Sinclair ZX Spectrum crashed, revealing it's BASIC source code. The ZX had a whopping 48K of memory which was considered to be a lot in the Commodore Vic20 era, but more importantly, it had BASIC built into the soft touch keyboard. Teaching myself to program, I coded my first commercial program at age 15.

After graduating high school at 17, I joined the South African Air Force, graduating the Academy and becoming a Pilot with the rank of First Lieutenant by age 20. After serving my country for six years, I made my way back into computer software.

Continuing my education, I graduated Suma Cum Laude from the Computer Training Institute before joining First National Bank where my work won the Smithsonian Award for Technological Innovation in the field of Banking and Insurance. Soon I met Will Coleman from Amdahl SA, who introduced me to a little known programming language named Huron/ObjectStar. As fate would have it, this unknown language and Y2K brought me to the USA in 1998.

I got involved with SharePoint after playing around with the Beta for SharePoint Portal Server 2003. Leaving my career at Rexnord to become a consultant in 2004, I was first awarded the Microsoft Most Valuable Professional Award for SharePoint in 2005, becoming only the 9th MVP for WSS at the time. I fulfilled a life long dream by pledging allegiance to the Flag as a US citizen in 2006. I met the love of my life and became a private consultant in 2008. I was honored to receive my ninth MVP award for SharePoint Server in 2013.

Leave a comment

You must be logged in to post a comment.