Excel 2007 Pivot table error "There are too many records to complete this operation"

[Cassandra Brokaw]

Hi,

I am using Excel 2007. My spreadsheet has a number of pivot tables looking
at a couple of different source data. Two of the pivot tables have
calculated fields in them, and this seems to be causing the issue when I
attempt to update the pivot tables. I get the message "There are too many
records to complete this operation". The data that this particular pivot
table is referring too is only 58,736 rows x 155 columns. This is within
Excel 2003 limits and supposed to be a piece of cake for 2007.

Has anybody even seen this issue with 2007, and more importantly any ideas
for a work around.



Many thanks

Cassandra.

 

[Cassandra Brokaw]

No-one at all has any ideas about this error?

 

[cuervo88]

No-one at all has any ideas about this error?

I have the same question. There is no way I'm hitting even close to
a record limit for my pivot table.... I can wipe out the raw data
and refill it, then it seems to work (sometimes)... I've had to be
very careful about when I choose to save this file! I'm looking
forward to an answer to this problem as well.

 

[Roger Govier]

Hi

If you, and Cassandra, want to send me copies of your problem files, I would
be happy to take a look and see if I can find what the problem is.

To mail direct, send to
roger at technology4u dot co dot uk
Change the at and dots to make valid email address