1. Downloading and Installing PowerPivot

This chapter walks you through the installation of PowerPivot and introduces you to the various elements within PowerPivot.

System Requirements

To install PowerPivot, you need a Windows version of Excel 2010, in either the 32-bit or the 64-bit variety.

PowerPivot will not work with legacy versions of Excel. Microsoft embeds the PowerPivot database inside of the Microsoft Excel workbook. This required new application programming interfaces (APIs) that were built in to Excel 2010 and were not available in Excel 2007 or earlier. It seems unlikely that Microsoft would ever retrofit Excel 2007 to work with PowerPivot. ...

Get PowerPivot for the Data Analyst: Microsoft now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.