Answered Question About Installing PowerPivot

  • Saturday, April 14, 2012 12:52 AM
     
     

    I have Office 2010; just downloaded & installed Power Pivot.  I can't get it to 'stick'.  I installed the AddIn, from .COM.  Here's an image:

    I hit 'OK' but I don't see any tab for Power Pivot.  If I close excel and re-open it, I still don't see the tab for Power Pivot.  I actually have to go to File > Options > AddIns > Manage > Com AddIns > Go . . . and it is UNCHECKED!!  I check it and hit OK, and it is STILL NOT ADDED.  I can't seem to AddIn the AddIn. 

    I just uninstalled PP from Control Panel > Programs and Features, and then reinstalled it.  Now, I still can't get Excel to load the PP tab.  Check out this view:

    PP seems to be disabled.  What do I need to do to get this working? 

    I'm using Windows 7 & Office 2010 Pro Plus.

    Am I missing something simple or what???


    Ryan Shuell

All Replies

  • Monday, April 16, 2012 3:31 AM
     
     Answered

    Thanks everyone!  It is working now!!

    I did some research on this a found a few useful things.  I followed all of the instructions here:

    http://blogs.msdn.com/b/ronpih/archive/2009/11/18/office-14-beta-2-powerpivot-for-excel-ctp3-you-must-install-office-shared-tools.aspx

    Then, follow these steps:
    1. Open Excel and select File->Options->Addins->Manage and select Disabled items in the dropdown.
    2. Click Go and then select: Microsoft.AnalysisServices.Modeler.FieldList.Addin.Integration
    3. Close and reopen Excel.


    Ryan Shuell

  • Tuesday, April 17, 2012 4:46 AM
    Moderator
     
     

    Hi Ryan Shuell,
    I am glad to hear that you have resolved the problem yourself and share the workaround with us. Thank you very much.

    Best Regards,


    Bruce Song [MSFT]
    MSDN Community Support | Feedback to us