Office 2013: Make sure it’s the Professional Plus version for PowerPivot

For Microsoft Dynamics NAV and CRM Reporting & Analysis

Microsoft Office 2013 is released and on the shelves. Be careful though – as to which version you buy – as Microsoft have introduced some restrictions designed to move users to better Office versions. The latest discovery is that more restrictive Office 2013 licensing affects the version at which you can install its PowerPivot business reporting tool.

Professional Plus for Powerpivot for Microsoft Dynamics NAV and CRM

Microsoft made PowerPivot, its easiest to use data-analytics reporting technology, available for use by anyone with any edition of Excel 2010 by installing the PowerPivot for Excel add-in. With Excel 2013, only those with the Office Professional Plus version of Office 2013 will have full access to Excel 2013's PowerPivot capabilities.

So if you are one of the many Microsoft Dynamics NAV or Dynamics CRM users that have used Excel for reporting on your sales or manufacturing data via an analysis services ‘cube’ you need to make sure you get at least the Professional Plus version of Microsoft Office 2013.