When you try opening an Excel 2010 PowerPivot workbook in Excel 2013 you will find that you are unable to manipulate the PivotTable. In addition, you will be prompted with an error message that asks you to upgrade the data model:
However, when you try to enable the PowerPivot add-in, you may not see it in the COM add-ins dialog box. This problem can happen because in Excel 2013, PowerPivot and the two new add-ins - PowerView and Inquire, are only available on certain SKUs (versions). These include:
Note: Power Pivot and Power View on the standalone retail 32-bit and 64-bit SKUs were added with the October 2013 updates. If you have one of these SKU's but do not see the add-in, please apply the most recent updates and test for improvement.
If you have purchased an Office 2013 or Office 365 SKU other than those listed above, you will need to return your product to the place of purchase or stop your current subscription to change to one of the products that does support these add-ins.
There are a couple of ways to work around this issue:
Access a machine that has one of the above-listed SKUs
If you have access to a machine that has one of the above listed SKUs, you can use the PowerPivot add-in on that machine to update the PivotTable and save the file. Once the PowerPivot data model is updated, then you can open and use the PivotTables on your other machines. Keep in mind that once updated, you cannot use the PivotTable in Excel 2010
Recreate the Workbook in 2013
If you do not have access to a machine with the PowerPivot 2013 add-in, you can rebuild your PivotTable in Excel 2013. There is no way to update the model, so you will need to import your data again and recreate the workbook from scratch. The data model engine is a part of Excel 2013. To do that:
If you have tables in Excel that you want to use, do the following.
For more information on Excel's built-in data model, see the following blog: http://blogs.office.com/b/microsoft-excel/archive/2012/08/23/introduction-to-the-data-model-and-relationships.aspx
The two new COM add-ins for Excel Power View and Inquire also require the same SKUS of Excel that PowerPivot does. You can find out more about the Power View add-in at http://blogs.office.com/b/microsoft-excel/archive/2012/10/04/intro-to-power-view-for-excel-2013.aspx.
You can also read more about Inquire at http://office.microsoft.com/en-us/excel-help/what-you-can-do-with-spreadsheet-inquire-HA102835926.aspx.