PowerPivot and PowerView Confusion in Office 2013

February 13th, 2013 by datapig Leave a reply »

OK. I've got lots of reader feedback expressing confusion and dismay that they can't seem to find PowerPivot or the new PowerView in Office 2103. These two components are typically referred to as BI functionality. It seems as though the BI functionality will not be included in all versions of Office 2103.


The handsome Jeff Weir points us to this article from Chris Webb's BI Blog explaining the entire thing.

Here are some key points from Chris Webb:

"For regular, non-subscription, Office 2013 on the desktop you need Office Professional Plus to use the PowerPivot addin or to use Power View in Excel."

"Professional Plus is only available via Open, Select or EA licensing. This means that no regular retail editions of Excel include PowerPivot or Power View, you can only get them through a Volume License Agreement or Office 365."

"Office Professional Plus 2013 will be available via Office 365 on February 27th 2013. The cheapest subscription option that includes Excel on the desktop with PowerPivot and Power View is, as far as I can see, this one…"

"The Excel Data Model and IS available in ALL desktop editions of Excel."


I'll limit my comments on Microsoft's Office 2013 licensing decisions to two words: Soup Sandwich.



  1. Lukas says:

    Leave it to Microsoft to make even hard core Excel fans ring their hands…

  2. They are doing everything in their power to make the non-subscription product unappealing. I’m surprised they don’t include a free pile of dog crap in every box.

  3. datapig says:

    John: I agree.

    First, there is no way to buy a standalone version of Excel with PowerPivot (only volume license).
    Second, there is no way to buy and install a PowerPivot Addin.

    They’re going to kill Powerpivot with this nonsense.

    It’s like saying: “Hey wasn’t that free PowerPivot in Excel 2010 nice? Good times right? Well now you have to buy 5 Excel licenses to keep using it in Excel 2013″.

  4. jeff Weir says:

    All this makes my apparently pretty head hurt.

  5. jeff Weir says:

    There’s another good discussion about this on Rob Collie’s blog at http://www.powerpivotpro.com/2013/02/hey-who-moved-my-powerpivot-2013-cheese/?utm_source=rss&utm_medium=rss&utm_campaign=hey-who-moved-my-powerpivot-2013-cheese

    My two cents repeated on this is that there’s an up-side to this for a consultant that knows how to mash together disparate data sources from Excel using VBA/ADO/SQL so that they all appear in one pivot…which of course is ENTIRELY possible with Excel 2003 let alone 2013. So the upside is that Powerpivot didn’t just shoot a hole in my target consulting market.

  6. Steve Schultz says:

    JWalk: any plans to offer PUP for the subscription product? (Or is it already oout there? I have’t looked, to be honest.)

Leave a Reply

Powered by sweet Captcha