1. Downloading and Installing PowerPivot
This chapter walks you through the installation of PowerPivot and introduces you to the various elements within PowerPivot.
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. ...