The PowerPivot add-in was developed for Microsoft Excel 2010 and supports its later versions. It does not support Microsoft Excel 2007, but in Microsoft Excel 2007, a user can only open the workbook since they are created in the .xlsx format. In Microsoft Excel 2007 users can only do Excel-level changes to the worksheet, such as change the color, font, and styles, but cannot interact with PivotTables and PivotCharts. When users upgrade PowerPivot, they can use the workbooks created in the previous versions but the opposite is not possible.
This chapter will cover the following topics: