PowerPivot and PowerView Confusion in Office 2013

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.

11 thoughts on “PowerPivot and PowerView Confusion in Office 2013

  1. datapig

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

  2. jeff Weir

    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.

  3. Steve Schultz

    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

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>