Excel 97 Pivot Table not compatible with Excel 2003


D

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?

Help.
 
Ad

Advertisements

S

Shane Devenshire

Hi,

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

Top