***
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

One of the founding engineers behind Power Pivot during his 14-year career at Microsoft, and creator of the world’s first cloud Power Pivot service, Rob is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology.

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.

  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.

  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?

  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.

  6. [email protected] says:

    Why doesn’t regular Office have it? Stupid.

  7. 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?

  8. 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.

Leave a Comment or Question