Hello guys,

I want to know that can we open higher version of pivot table created in office 2013 using sql 2014 to be open in lower version office 2007 or office 2003.or vice versa 

If yes please reply

i have gone through some solution that using office compatible pack install or adding add on of office new version we can open but want to know weather this apply to excel only or it apply to pivot also.

If you want me to improve my question than please ping 

Thank you in advance 

• Moved by Patrick_LiangMicrosoft contingent staff Friday, June 26, 2015 6:34 AM Excel issue

Hi,

Every Excel version will add some new features, thus, It's important to understand the dynamics of working with the different program versions and the different PivotTable format versions to decide whether you can use them with different version. Please read this article:

https://support.office.com/en-ca/article/Working-with-different-PivotTable-formats-in-Office-Excel-ac2d418b-61f7-46f9-8031-d584ab32b906

Then, since you said >>i have gone through some solution that using office compatible pack install or adding add on of office new version we can open but want to know weather this apply to excel only or it apply to pivot also.<< It's yes.

More reference:

https://support.microsoft.com/en-us/kb/924074

https://support.office.com/en-nz/article/Save-an-Excel-2013-workbook-for-compatibility-with-earlier-versions-of-Excel-a1ed5fc0-c257-4d85-b342-73a30c65348c

Regards,

George Zhao
TechNet Community Support