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!

"douglas" wrote:

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