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

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

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
 

Watch MrExcel Video

Forum statistics

Threads
1,089,992
Messages
5,411,712
Members
403,392
Latest member
Faster 72

This Week's Hot Topics

Top