Pivot Table turns into normal data?

[ridz89]

Hi Guys,

I've never come across this before, after opening a file with Pivot Tables. They have now just turned into normal tables without the pivot functionality.....Does anyone know why this happens? or how to prevent it.

Using Excel 2013, saved my workbook as .xls

 

[RoryA]

If the pivot table was created as a later version it can't be converted back to an earlier version - you have to create the xls file first and then add the pivot table to it.

 

[ridz89]

Thanks Rory. Thanks for confirming its a version issue, I was pulling my hair out lol.