Excel 97 Pivot Table not compatible with Excel 2003


D Bremer

Is there a way to share/ use a pivot table in Excel 2003, when it is created
in Excel 2007 and saved as the previous version?




Shane Devenshire


You subject line says Excel 97 but you post suggestes 2007.

Pivot tables made in 2007 are not compatible with 2003. When a 2003 user
opens them they will not be able to do anything with them. When they are
returned to 2007 the will regain their functionality.

If you want to make a pivot table compatible - open Excel 2007, save the
file as a 2003 file, close the file and reopen it in compatibliity mode.
Make your pivot table. Save and close it. Open it in 2003. It will work.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question