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.
 
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

Similar Threads

Excel 2007 Pivot table refresh crashes 2
Excel 2007 Pivot Table Disappears 1
Error message when trying to refresh pivot table in Excel 2007 0
Access #Error & Excel Pivot 0
SOS!!! Excel 2007 Pitvot Tables Created in Old Format 2
problem with excel 2007 opening excel 2003 created spreadsheet 2
2nd Pivot Table on Worksheet Crahes Excel 1
Pivot Table Error in 2007 - missing data when refreshed 1

Top