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!
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

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,089,195
Messages
5,406,753
Members
403,105
Latest member
gituncar

This Week's Hot Topics

Top