Pivot

Wimad

New Member
Joined
Nov 25, 2008
Messages
2
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!
 

Wimad

New Member
Joined
Nov 25, 2008
Messages
2
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
 

Forum statistics

Threads
1,084,856
Messages
5,380,319
Members
401,664
Latest member
traveler84

Some videos you may like

This Week's Hot Topics

Top