skip to Main Content

Update Oct 11, 2013:  I’ve been given the “all clear” by Microsoft and from readers that as of this week, Excel 2013 Standalone DOES include and successfully install Power Pivot!

See this post for details.


After a few readers of last week’s post reported that installing Standalone did NOT add Power Pivot and Power View, we followed up with my contacts at Microsoft.

Microsoft quickly tracked down a problem in the upgrade logic, and it will be fixed in the September 10th update (that gets automatically downloaded).  So hold tight until then.

Rob Collie

Rob Collie

One of the original engineering leaders behind Power BI and Power Pivot during his 14-year career at Microsoft, Rob Collie founded a consulting company in 2013 that is 100% devoted to “the new way forward” made possible by Power BI and its related technologies. Since 2013, PowerPivotPro has rapidly grown to become the leading firm in the industry, pioneering an agile, results-first methodology never before seen in the Business Intelligence space. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team would like to help you revolutionize your business and your career.

This Post Has 39 Comments
  1. Any idea if this applies globally? I’m in the UK and would like to know if this is the “fix” I’ve been waiting for. Still massively annoyed that Home and Business 2013 doesn’t contain the features of Home and Business 2010.

    Also, how backward compatible are powerpivots between 2010 and 2013? Both those created in 2010 and modified in 2013 and vice versa.

    1. I just downloaded a German language Version, the Powerpivot addin was not included, even though I read somewhere it should be.

      The patch that supposedly would install it (KB2817425) found that it there was no version of Excel installed for which it was applicable.

      Well, great! 🙁

  2. There must be only 2 or 3 of us who bought Excel 2013 standalone, thinking it had PowerPivot included.
    – nobody seems to care very much. No news ANYWHERE that I can find.
    – – – Sure would appreciate any information anyone has as to when this might happen (didn’t seem to happen with the September 10th update.

    1. Yeah, there was some sort of setback on the rollout of the September 10 fix. My former colleagues have now made liars of me and other community pros several times on this one issue. Stay tuned. You will know something as soon as I do.

  3. If there are problems with the update, why isn’t it at least included in new downloads of the full package? Or isn’t there no click-to-run Excel/Office Version that has Excel with Powerpivot?

    1. Ok, just seen the “retail” download is pretty big, almost 2Gb, I guess that could be part of the reason they will only want to change the full download when the update does work.

    2. I was able to add Power Query and Power Map Preview to an Excel 2013 Retail stand-alone version, I think that was not possible before. Makes you wonder why it is so difficult to make Power Pivot available.

      1. Mmh, Power Qery now also shows up in a Office 2010 Home and Student version that is installed on the same computer. Nice, but probably unintentional??

    1. Not sure if you are still looking, but you have to download both from Microsoft. Both are only available for Excel 2013.

      However, after having installed them on a machine that has Excel 2013 and Excel 2010 side-by-side, I could use Power Query in Excel 2013 AND also in Excel 2010.

      Power Map has compability issues and apparently does not work in 2010.

  4. New and improved add-ins and converters
    Power Pivot for Excel add-in
    If you’re using Office Professional Plus, the Power Pivot add-in comes installed with Excel. The Power Pivot data analysis engine is now built into Excel so that you can build simple data models directly in Excel. The Power Pivot add-in provides an environment for creating more sophisticated models. Use it to filter out data when importing it, define your own hierarchies, calculation fields, and key performance indicators (KPIs), and use the Data Analysis Expressions (DAX) language to create advanced formulas. Learn more about the Power Pivot in Excel 2013 add-in.

    This is the information you get about Excel from Microsoft. Date 2013-10-21

  5. Hi:

    I purchased Office 2013 Pro before I knew it did not have Power Pivot. Can the standalone version be loaded over my copy of Excel 2013 in office or could I have 2 copies of Excel 2013 on my computer? Microsoft says you have to have the volume licensing of the standalone version. I only need 1 copy of the software. They are not much help at Microsoft.

    Your help is appreciated.

    1. Standalone Excel 2013 CAN be installed “over the top” of 2013 Pro, and that WILL add Power Pivot. Confirmed now by multiple readers 🙂

      1. Thanks for your prompt reply. So the standalone version does not need to be volume licensing? I can just go to Amazon, etc. and buy a single version and it will work?

        Thanks again!

          1. Thanks again for the information. You made my day. I purchased a standalone version of Excel 2013 from Staples. I loaded it over my Office 2013 Professional. It worked. I am a happy camper.

  6. I have Office Professional 2013 (with latest update 15.0.4551.1005) and do not see PowerPivot in the “COM Add-ins”. Does anyone know where I need to go to get the add in file? Is this still not available to Office Professional (not Professional Plus) users?

    1. You need Excel Standalone installed over the top of Pro, OR you need Pro Plus. Regular Pro by itself will not have Power Pivot.

      And yes, I agree that sucks. Getting Power Pivot “back” in Standalone was a step in the right direction for sure, but not as “correct” as it should be.

  7. I have ProPlus (part of 365 Small Busimess Premium) with latest update (15.0.4551.1512) installed. Works fine on 1 Laptop but not available on other laptop or desktop. Have tried all suggested fixes (Regedit included) plus reinstalled on all 3, SNAFU??? Any ideas would be extremely appreciated. MS not helping.

    Confused & frustrated Aussie.

    1. The only way to add Power Pivot to 2013 Home and Student is to install Excel Standalone on top of it (which works great but costs roughly $100).

Leave a Reply

Your email address will not be published. Required fields are marked *