Power Pivot and Power View now available in Excel Stand-alone

By | August 19, 2013

The Excel team has made some changes necessary to the Excel code that allows Power Pivot and Power View to run in Excel Stand-Alone version. So you can now purchase a retail SKU that has Power Pivot and Power View in them. The Excel 2013 box (aka Excel 2013 standalone SKU) will now include the add-ins when installed. This will be the first offering of Excel that will allow you to go to the store and physically buy Power Pivot and Power View embedded in Excel 2013.  If you have already purchased this SKU, the next time Office updates via Click-to-Run, you will have the add-ins.

For more information on what version of Office contain Power Pivot and Power View see this blog post on the Excel support team blog. These are the SKU’s that have both add-ins:

 

 

  • Colum

    Hi Kasper,
    I just purchased a standalone Excel 2013 based on this post suggesting that it supported Power View and Power Pivot, however, it appears that no add-ins for either are available in the File>Options>Add-ins menu. Am I missing something? I was able to download the Power Query add-in from the Microsoft site, but couldn’t find equivalent add-ins for Power View and Power Pivot. What am I missing?
    Thanks.
    Colum

  • Kasper de Jonge

    Hi Colum, How did you get your version of Office? And can you please check the version number (Go to File–> Account)?

    Did you try to run Office update? That should bring older versions of Office up to date (again available through File –> Account).

    Thanks,
    Kasper

  • Colum

    Kasper,
    I have Office 2010 installed …
    I didn’t want to update all office apps to 2013 but was just interested in Excel 2013 … given the availability of Power Pivot and Power View as part of the standalone.
    I purchased Excel 2013 from the Microsoft Store here:
    http://www.microsoftstore.com/store/msusa/en_US/pdp/Excel-2013/productID.259321300
    It appeared to install OK in the background … and seems to be the latest version available (15.0.4517.1509), but is missing the Power Pivot and Power View add-ins.
    I then came across this potential fix and downloaded the 32bit version (since the install above is 32bit … recommended by MS … even if my system is 64 bit).
    http://support.microsoft.com/kb/2817425
    This shows a dialogue box with EULAID:015_RTM_CLT.1_SUPP_EN
    When I select accept terms and ‘Continue’ … I get “There are no products affected by this package installed on this system” … eventhough Excel 2013 is installed.
    Not sure what the issue is.
    Colum

  • Kasper de Jonge

    Hi Colum,
    Thanks for reporting this, I have provided this information to the Excel support team and they are investigating.

    Thanks,
    Kasper

    • Kasper de Jonge

      Hi Colum,

      Microsoft has found an issue with the August release of Excel 2013. This issue will cause the Power View and Power Pivot add-ins to not be able to load in Excel Retail Standalone 32- and 64-bit. This issue will be addressed as part of the Excel 2013 September update. You should automatically get this update.

      Thanks,
      Kasper

  • The latest september update (11th) does not seem to include this either. Am I missing something?

  • admin

    Nope you are right, hang on tight. It will show up.

  • Kasper,
    I have not repurchases Excel 2013 yet, as I wanted to establish whether the standalone version has finally resolved the issue with Power Pivot and Power View? I see from the comments to this blog that issues remain unresolved up until early October at least.
    Thanks for your assistance.
    Colum

    • Kasper de Jonge

      It has been resolved now.

  • So I am still confused. I own MS OFFICE 2013 Professional addition. I have LARGE data sets, well over 10mg. What option do I have to actually get PowerPivot. Since I bought MS OFFICE when I had my maschine built, the only way I can get my money back for it, is to send my machine back to Lenovo. That would put me in a horrible position at work, to be within my machine even one afternoon is rough, for over 7 days, is impossible. What options do I have?