none
Help, PowerPivot in Excel 2013 is missing RRS feed

  • Question

  • hi

    I recently change excel 2013 preview to excel profesional 2013 but PowerPivot is missing, what do I have to do, It`s not in the COM add-ins list, I tried too many ways, somebody can help me.

    Thursday, February 21, 2013 8:14 PM

Answers

  • Hi mlvmx,

    PowerPivot in Excel 2013 is an add-in you can use to perform powerful data analysis in Excel 2013. The add-in is available in Microsoft Office Professional Plus. It’s built-into Excel 2013 but is not enabled. Here’s how you enable PowerPivot before you use it for the first time.

    1. Go to File > Options > Add-Ins.
    2. In the Manage box, click COM Add-ins> Go.
    3. Check the Microsoft Office PowerPivot for Excel 2013 box, and then click OK. If you have other versions of the PowerPivot add-in installed, those versions are also listed in the COM Add-ins list. Be sure to select the PowerPivot add-in for Excel 2013.

    For more information, please see: http://office.microsoft.com/en-001/excel-help/start-powerpivot-in-excel-2013-add-in-HA102837097.aspx

    Regards,


    Elvis Long
    TechNet Community Support

    Tuesday, February 26, 2013 1:14 AM
    Moderator
  • Check this out - :(

    http://www.powerpivotpro.com/2013/02/hey-who-moved-my-powerpivot-2013-cheese/

    Update

    Find below the excerpt from MSFT employee

    "Hi all,

    We understand that this puts those of you who have less than ProPlus in a bad position where your previous Excel 2010 workbooks are concerned. You can't use them in Excel 2013 without updating the data model, and you can't update the data model without the add-in. If you know someone with ProPlus or an Enterprise SKU, you can always ask them to update the workbook and save it in 2013. From there, you should be able to use it.

    For basic PowerPivot functionality, you don't need the add-in. So you can also recreate your PivotTables in Excel 2013 using the new data model. The key is to select "Add this data to the data model" when you create the pivottable from one of your data sources. Then you can import other tables, and use the "All" tab on the field list to add the other information. On either the Data tab or the PivotTable tools Analyze tab, you can create the relationships you need.

    Hope this helps!
    Anita"


    Cheers,
    Jason | www.SqlJason.com
    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

    Some Random Thoughts

    Follow me on Twitter


    Thursday, February 21, 2013 9:12 PM
    Answerer

All replies

  • Check this out - :(

    http://www.powerpivotpro.com/2013/02/hey-who-moved-my-powerpivot-2013-cheese/

    Update

    Find below the excerpt from MSFT employee

    "Hi all,

    We understand that this puts those of you who have less than ProPlus in a bad position where your previous Excel 2010 workbooks are concerned. You can't use them in Excel 2013 without updating the data model, and you can't update the data model without the add-in. If you know someone with ProPlus or an Enterprise SKU, you can always ask them to update the workbook and save it in 2013. From there, you should be able to use it.

    For basic PowerPivot functionality, you don't need the add-in. So you can also recreate your PivotTables in Excel 2013 using the new data model. The key is to select "Add this data to the data model" when you create the pivottable from one of your data sources. Then you can import other tables, and use the "All" tab on the field list to add the other information. On either the Data tab or the PivotTable tools Analyze tab, you can create the relationships you need.

    Hope this helps!
    Anita"


    Cheers,
    Jason | www.SqlJason.com
    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

    Some Random Thoughts

    Follow me on Twitter


    Thursday, February 21, 2013 9:12 PM
    Answerer
  • Hi mlvmx,

    PowerPivot in Excel 2013 is an add-in you can use to perform powerful data analysis in Excel 2013. The add-in is available in Microsoft Office Professional Plus. It’s built-into Excel 2013 but is not enabled. Here’s how you enable PowerPivot before you use it for the first time.

    1. Go to File > Options > Add-Ins.
    2. In the Manage box, click COM Add-ins> Go.
    3. Check the Microsoft Office PowerPivot for Excel 2013 box, and then click OK. If you have other versions of the PowerPivot add-in installed, those versions are also listed in the COM Add-ins list. Be sure to select the PowerPivot add-in for Excel 2013.

    For more information, please see: http://office.microsoft.com/en-001/excel-help/start-powerpivot-in-excel-2013-add-in-HA102837097.aspx

    Regards,


    Elvis Long
    TechNet Community Support

    Tuesday, February 26, 2013 1:14 AM
    Moderator
  • I have this problem and have tried all recommended fixes including Regedit. Neither of the HKEY Current user lines for Win 8 are there?? This problem has existed for 2 of 3 my PC's since installation. The other 1 has no issues. Have made several calls to MS without luck (transferred many times - see Issue No# 1231686119). Where to from here???? Any help would be appreciated.

    Monday, January 20, 2014 3:20 AM
  • I have installed Microsoft Office Professional Plus 2013 on a VM, and Power Pivot is not showing up in my add-ins. There is also no Power Pivot folder in the add-ins folder in my Program Files, only Power View.

    This does not happen with the same installation on my local environment, only on the VM. The VM in sunning Windows 7 with Office 64bit. My local machine is running Windows 8 with Office 64 bit.

    Is this a known issue, or have I missed something in the installation?

    Thursday, March 27, 2014 5:36 PM
  • Try running the fix it tool from here : http://support.microsoft.com/kb/2805999
    Thursday, August 14, 2014 5:46 PM
  • I am having the same issue. on my boss's pc, power pivot does not show up in the com add ins. It is also missing the registry keys. We tried running the fix tool and it did nothing. We also ran a full repair and that also did nothing. Does anyone else have any idea on how to fix it from there?
    Thursday, August 28, 2014 5:49 PM
  • Hello Jonathan,

    And which Edition is used, also Professional Plus 2013?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, August 29, 2014 7:34 AM
    Moderator
  • Pro Plus 2013
    Friday, August 29, 2014 12:50 PM
  • We were able to get it fixed. It took a complete uninstall and reinstall of Office, but he now has the Power Pivot add in.

    Friday, August 29, 2014 7:13 PM
  • Hi All,

    I have the same issue with Power Pivot add-in, it does not show in registry keys or add-in folder under program files.

    We have installed Office 2013 professional Plus 32 bit on Windows server 2012R2 datacentre 64bit platform.  Microsoft fix it tool doesn't run on this machine (http://support.microsoft.com/kb/2805999)

    looks like there is no solution other than complete uninstall and reinstall?

    Thanks

    Sonny

    Tuesday, September 2, 2014 6:33 AM
  • That was the only thing that helped me. I tried everything from repair to registry keys. Only the complete uninstall and reinstall worked for me.

    -Jonathan

    Wednesday, September 3, 2014 3:43 PM
  • Thanks Jonathan,

    Just to clarify the steps in complete uninstall and install

    1. uninstall Excel from programs and features

    2. maybe restart server

    3. Install from software download or cd

    sonny

    Wednesday, September 3, 2014 10:55 PM
  • That would be the steps I would take. I would reboot the server for sure before trying to reinstall the software.

    -Jonathan

    Monday, September 8, 2014 7:53 PM
  • Mr. Long,

    You obviously did NOT read the whole plea for help. "it is NOT in the COM add-ins list." I am having the same issue. I wish Microsoft would correct differences with add-ins and such between the different versions of Office. It should not matter what PC you are on or that you have Office Home and Student 2013 (which is what I have) or Pro, etc. It makes it difficult to use certain functions. I am taking an Excel class and the book we are using the book "GO! with Microsoft Excel 2013" and the instructions are the same as what you have stated. I will have to ask the Professor what my options are.

    Thursday, November 6, 2014 6:23 PM
  • We had the same issue, tried the registry fix but no luck. We fixed it by going into Control Panel > Programs and Features > selecting Microsoft Office Pro Plus 2013 > selecting Change > Add or Remove Features > Continue > click the + next to Microsoft Excel + Add-ins > drop down next to PowerPivot and selected Run from My Computer > Continue and then went back into Excel and it was now an available add-in under com add-ins. Looks like the default installation didnt install PowerPivot. 
    • Proposed as answer by Michael E Regan Tuesday, November 25, 2014 10:45 PM
    Thursday, November 20, 2014 4:08 PM
  • We had the same issue, tried the registry fix but no luck. We fixed it by going into Control Panel > Programs and Features > selecting Microsoft Office Pro Plus 2013 > selecting Change > Add or Remove Features > Continue > click the + next to Microsoft Excel + Add-ins > drop down next to PowerPivot and selected Run from My Computer > Continue and then went back into Excel and it was now an available add-in under com add-ins. Looks like the default installation didnt install PowerPivot. 
    Thanks so much ..tried all the registry hacks and the repair tools.... and all along it was just not added in correctly... working perfectly now..
    • Proposed as answer by damontes Friday, July 17, 2015 6:33 PM
    Friday, March 20, 2015 9:12 AM
  • Thanks for the advice. Problem solved!

    /Jakob

    Friday, April 24, 2015 7:33 PM
  • Great,

    The company updated to 2013 but the add-in wasn't installed. Now it works!

    Thanks

    Friday, July 17, 2015 6:34 PM
  • Go to Control Panel>Programs and features.  Select Microsoft Office Professional Plus 2013.  At the top of the pane, select "Change".   A dialog box with four radio buttons should open; select "Add or Remove Features".  Another box will open, listing the applications within Office.  Click the "+" next to Microsoft Excel, then click the "+" next to Add-Ins.  Find "Power Pivot" from the list under Add-Ins and click on the red "X" that appears next to it.  Select "Run from my computer" and click the "Continue" button in the lower right corner.  Once configuration is complete, exit all Office applications that are open, then reopen Excel.  The COM add-in for Power Pivot should now be available. 

    • Proposed as answer by XLGoddess Wednesday, March 29, 2017 3:38 PM
    Saturday, October 24, 2015 5:34 PM
  • This worked for me and I tried the Fixit and looked for the registry keys first-niether worked.  

    Thanks!

    Tuesday, March 15, 2016 5:02 PM
  • We had the same issue, tried the registry fix but no luck. We fixed it by going into Control Panel > Programs and Features > selecting Microsoft Office Pro Plus 2013 > selecting Change > Add or Remove Features > Continue > click the + next to Microsoft Excel + Add-ins > drop down next to PowerPivot and selected Run from My Computer > Continue and then went back into Excel and it was now an available add-in under com add-ins. Looks like the default installation didnt install PowerPivot. 

    Success! This is the piece of the puzzle that people seem to be missing here. Thanks so much for the input.

    Wednesday, May 18, 2016 3:39 PM
  • Gotta love it when a tech expert repeats back to someone what they just said didn't work.  Sheesh.
    Friday, March 3, 2017 4:00 PM
  • Thanks a lot. This worked perfectly for me.
    Thursday, July 13, 2017 7:17 PM