

PowerPivot workbooks can be opened in Excel 2007. After you create the workbook, you can publish it to a SharePoint Server 2010 farm that has Excel Services and a deployment of SQL Server PowerPivot for SharePoint.

Creating an Excel workbook that contains PowerPivot data requires both Excel 2010 and the PowerPivot for Excel add-in.
