Excel 97 Pivot Table not compatible with Excel 2003

  • Thread starter Thread starter D Bremer
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

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

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

Back
Top