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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

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,675
Messages
5,409,659
Members
403,274
Latest member
Lewis1995

This Week's Hot Topics

Top