But with Excel 2013, the latest version of Microsoft's spreadsheet program, only those with the Office Professional Plus version of the new Office will have full access to Excel 2013's BI capabilities.
The Excel/Microsoft BI community is none too happy about Microsoft's decision to restrict full PowerPivot functionality, as is evident in the comments from various blog posts on the topic. A few choice ones from posts on PowerPivotPro.com and DataPigTechnologies.com:
"So much for BI for the masses, I guess. Large corporation have BI solutions anyway, but small companies suddenly had access to a great BI solution, and without sharepoint, you had to rely on everybody haviing the newest version of Office."
Update: What's Microsoft saying about this latest licensing revelation? I asked and an Office team spokesperson and got this revised (as of February 19) statement:
"People can get PowerPivot and Power View with one of the following options:
Office Professional Plus 2013 via Open, Select or Enterprise Agreement;
Excel 2013 standalone via Open or Select;
Office 365 ProPlus via Office 365 when it becomes available 2/27/13.
"After introducing these capabilities broadly in our 2010 releases, we found that businesses were the primary users of these advanced business intelligence features in Excel, so we’ve made them available via the licensing programs businesses already use. Businesses can get these capabilities with a minimum of 5 Office licenses via most licensing programs or with an individual Office 365 ProPlus subscription."
A number of commenters on aforementioned blogs noted that unless every Excel user has full access to all the PowerPivot functionality, Microsoft's BI technology has less of a chance for full acceptance. Small business users may not be willing or able to purchase Office Professional Plus, which is available to volume licensees and will be part of the Office 365 Small Business Premium Service (but not the cheaper Office 365 Small Business one). And students are highly unlikely to have access to the Professional Plus SKU, either, some have noted, which could limit the pool of entering the workforce who are already conversant with Microsoft's BI technology.
Microsoft officials acknowledged late last week that users purchasing all standalone Office 2013 product are licensed to use it on one PC only. (In other words, the license is non-transferrable.) Microsoft is offering users who want the new Office the right to install Office 2013 on multiple computers, but only if they purchase Office 365 Home Premium, a subscription version, rather than the one-time, perpetually licensed Office 2013 product.