none
Can't get PowerPivot to show up in excel

    Question

  • I have uninstalled office 2010 and Powerpivot, reinstalled per forum comments and still nothing. I do have .NET 4 installed. Any ideas?

    1. Open Excel and select File->Options->Addins->Manage COM addins.
    2. Put a checkmark in the box for the PowerPivot for Excel addin and click OK.

    I have also tried

    • Click on the Environmental Variable
    • Click on New User Variable
    • Add VSTO_SUPPRESSDISPLAYALERTS with value 0 press OK
    • Nothing!
    Tuesday, March 08, 2011 7:28 PM

Answers

  • Hi Raul, If you are using PowerPivot (SQL Server 2008 R2) 10.50.*.* then you need to have .net 3.5 and pick Office Shared Tools and Office Tools entirely while installing Excel. If you are using PowerPivot 11.0.* CTP2 (Code named Denali) then .Net 4.0 and VSTO for .Net 4.0.

    Hope this helps!

     


    Thanks, Deva [MSFT] My blog: http://powerpivot.spaces.live.com/
    Tuesday, April 05, 2011 3:35 PM

All replies

  • Hi,

    i'm having the same problem, did you ever solve it?

    thanks!!


    Raul Queiroga, Microsoft Partner and MCP
    Wednesday, March 30, 2011 6:59 PM
  • 1) make sure you have office shared and Office tools selected in the Office installation

    2) Can you try repairing .Net 3.5, restart the box and try again?

     


    Thanks, Deva [MSFT] My blog: http://powerpivot.spaces.live.com/
    Thursday, March 31, 2011 5:17 AM
  • Hi Deva,

    my office instalation has all the components and I have .net 4.0 and not 3.5...chould I try reparing it? I already tried the VSTO_SUPPRESSDISPLAYALERTS flag and reainstalling the powerpivot addin completely, and nothing..

    thanks for your reply


    Raul Queiroga, Microsoft Partner and MCP
    Monday, April 04, 2011 10:36 AM
  • Hi Raul, If you are using PowerPivot (SQL Server 2008 R2) 10.50.*.* then you need to have .net 3.5 and pick Office Shared Tools and Office Tools entirely while installing Excel. If you are using PowerPivot 11.0.* CTP2 (Code named Denali) then .Net 4.0 and VSTO for .Net 4.0.

    Hope this helps!

     


    Thanks, Deva [MSFT] My blog: http://powerpivot.spaces.live.com/
    Tuesday, April 05, 2011 3:35 PM