Pivot

[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)

Pls help.

Tks!

 

[Andrew Poulsom]

Do you know what limit you are exceeding?

http://office.microsoft.com/en-us/excel/HA100778231033.aspx#PivotTable

 

[Wimad]

Hi,

All I can see is this message:

A PivotTable in this workbook exceeds former limits and will be lost if it is saved to earlier file formats. Only PivotTables that are created in Compatibility

I acnnot see that this is related to the number of obkjects allowed in 2003 because the pivot works ok until I create the Calculated field - even if I don't drag it into the table it still won't save. The moment I delete the calculated field it's OK.

Tks