Pivot table Excel 2013

I have a workbook with extensive pivot tables created in Excel 2013. However, Im using 2010 Excel version. Im able to see data, however, when I tried to filter I get an error message telling me the pivot table was created in a later version of excel and can't be updated in this version. I think this is happening because the author created the pivot table in 2013 using PowerPivot and it appears Excel 2013 is not backwards compatible. Is there a workaround to be able to view the DAX code within Excel 2012 PowerPivot?

August 26th, 2015 11:11am

Hi NDT,

In Excel 2013, data models are built into the software. If you upgraded an Excel 2010 PowerPivot workbook to Excel 2013, or created a new Excel 2013 workbook from the ground up that contains a data model, the workbook has limited backwards compatibility. You can open and view the workbook in Excel 2010, but you won't be able to modify or manipulate Pivot Tables or Pivot Charts.

Within an organization, everyone using data models or model-based workbooks should run the same version of Excel, either using Excel 2010 with the PowerPivot add-in for Excel 2010, or upgrade to Excel 2013 to use the embedded data model and data visualization features that are part of that release.

I suggest you can refer to these articles to get more information:
https://support.office.com/en-us/article/Upgrade-Power-Pivot-Data-Models-to-Excel-2013-c66578cb-74d5-43ae-a474-5a01be5db439?CTT=1&CorrelationId=441aa2b0-14de-47da-9a35-4e7788ab2428&ui=en-US&rs=en-US&ad=US

https://support.office.com/en-us/article/What-s-new-in-Power-Pivot-in-Microsoft-Excel-2013-930be6c5-e839-4860-8c74-8a5e2cba1279?CTT=1&CorrelationId=8d3bb1d4-0b17-44bf-a554-12865c1b229a&ui=en-US&rs=en-US&ad=US

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su

Free Windows Admin Tool Kit Click here and download it now
August 27th, 2015 4:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics