Search This Blog

Issue-This workbook has a Powerpivot data model created using a previous version of the Powerpivot add-in. You’ll need to upgrade this data model with Powerpivot in Microsoft Excel 2013

Powerpivot Excel 2010 Issue in Excel power pivot 2013


Issue-Excel 2010 Powerpivot Report Not working in excel 2013
Error-This workbook has a Powerpivot data model created using a previous version of the Powerpivot add-in. You’ll need to upgrade this data model with Power Pivot in Microsoft Excel 2013
,


Issue Description-We were having Some of Power Pivot Reports which we created using Excel 2010 Powerpivot when we edited those Report in Excel 2013 those were showing below errors.
This workbook has a Powerpivot data model created using a previous version of the Power Pivot add-in. You'll need to upgrade this data model with Powerpivot in Microsoft Excel 2013

Issue Solution-Click on
 PowerPivot tab
Manage
It will show the error message again
click ok
This workbook has a Powerpivot data model created using a previous version of the Power Pivot add-in. You’ll need to upgrade this data model with Powerpivot in Microsoft Excel 2013
click Ok  as below Screenshot.



Next it will ask to upgrade the excel book
Click ok

It will upgrade the excel and restart the excel file again
Now the Report has been converted to excel 2013 and you can edit it in excel 2013.

1 comment:

  1. Thank you, it fixed the issue with my excel file.

    ReplyDelete