excel pivot tables

D

douglas

I have created an excel workbook 2007 and have saved lotsof pivot tables in
each tab. I need to have these spreadsheets in excel 2003 since that is what
most of my users have.
The problem is that when I save as the excel 2003, the data is saved
including the pivot tables. However once a user tries to with the pivot
tables and try to modify the pivot tables, the pivot table in 2003 does not
work.
Thus is there any way to save an excel 2007 spreadsheet with the
corresponding pivot tables and have the pivot tables work that they should
for an excel 2003 user?

Basically how can you save a excel 2007 pivot table in a format for a 2003
excel pivot table user?

Thansk!
 
A

Arnold

douglas said:
I have created an excel workbook 2007 and have saved lotsof pivot tables in
each tab. I need to have these spreadsheets in excel 2003 since that is what
most of my users have.
The problem is that when I save as the excel 2003, the data is saved
including the pivot tables. However once a user tries to with the pivot
tables and try to modify the pivot tables, the pivot table in 2003 does not
work.
Thus is there any way to save an excel 2007 spreadsheet with the
corresponding pivot tables and have the pivot tables work that they should
for an excel 2003 user?

Basically how can you save a excel 2007 pivot table in a format for a 2003
excel pivot table user?

Thansk!

Hi Douglas

Really simple, When saving the file save as Excel 97-2003 workbook. Should
work.
Arnold
 

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