Pivot Calculated Field

G

Guest

I'm trying to insert a calculated field in my pivot table and I'm getting a
"there are too many records to complete this operation" error. I have about
10,000 records in the data sheet. Has anyone encountered this? Is there a
way around it?
 
M

MandyU

I just encountered this problem yesterday.
The only thing that I was able to identify as a problem was that the
pivot table was created with Office XP, and didn't seem to work under
Office 2003. Running the same operation on a machine that hadn't yet
been upgraded to 2003 worked fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table calculated item 4
Mystery field in pivot table 8
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Calculates field in pivot table 2
Pivot tables - memory issues - please help 2
how do I remove #DIV/0! in a pivot table calculation field ? 2
Limitations for Calculated Field formulas in Pivot Tables 1
Calculated field in Pivot Table 2

Top