Pivot table 2007 saved as 2003

[Wimad]

Hi,

I use a pivot (2007) to read data from SQL (ODBC) which I have to store in
2003 format. If I save, I get the warning that functionality will be lost: "
PivotTable in this workbook exceeds former limits". I use a calculated field
as well (dividing two simple amounts) and if I remove this field then there
is no problem in saving to 2003 version. (108 000 records in SQL table) I am
in compatible mode.

Pls help.

Tks!

 

[Shane Devenshire]

Hi,

And what's your question, you found the problem, you found one solution, the
other would be to leave the pivot table in 2007 format. The 2007 pivot table
support far more unique items than 2003 and has a number of other increases,
not all of which are fully documented. You could create your pivot table in
2003 and see if you have a problem.

Cheers,
Shane Devenshire