PowerPivot file extension

PowerPivot ( what is powerpivot? ) is stored within Excel files and as such are just normal workbooks, and there is no PowerPivot file extension as such. However, it is important to note that not all Excel file types will save the PowerPivot information and you should only use the approved extensions.

Related: Learn how to use PowerPivot

Firstly, any Excel file extension based on Excel 2003 or earlier will not store the PowerPivot information. Also, any extenstion that is not native Excel (open source files etc.) will not store the PowerPivot.

The file types you can use when saving a PowerPivot are:

Excel Workbook (*.xlsx)
Excel Binary Workbook (*.xlsb)
Excel Macro-Enabled Workbook (*.xlsm)

You can see more about Saving a workbook with PowerPivot on the Microsoft site. To learn more about PowerPivot ask us about the PowerPivot courses we offer