PowerPivot Compatibility across versions
There are several versions of PowerPivot available and starting with Excel 2013 there are also several versions of Excel. It is useful to look at the compatibility between the different versions of Excel and PowerPivot available now.
As a general rule when you have a PowerPivot workbook saved with a specific version of PowerPivot:
- You can upgrade a workbook to a newer version of PowerPivot
- You can upgrade a workbook to a newer version of Excel
- You cannot open a workbook using a previous version of PowerPivot
- You cannot open a workbook using a previous version of Excel, if it contains PowerPivot data