pivot table error:Too many records to complete this operation

[MumfordAg]

Working with prior functioning pivot table and after adding another worksheet
in workbook, when I want to refresh pivot table, recieve the error message "
Too many records to complete this operation" I did not change the record
number. I can not change anything on the pivot table such as reduce columns,
rows or anything that would allow me to reduce the size of my pivot table. I
only have 500 rows in table that is providing the pivot table data. I
removed the worksheet I added but still receive same error. Anything I select
on pt worksheet I receive this error. ??

 

[ker_01]

You didn't include it in your post, but I'd guess you are working in Excel
2003 and that you set up your pivot table in a way that brings in at least
255 different values into the columns- this would exceed the number of
columns available in Excel 2003, and would give Excel indigestion.

HTH,
Keith

 

[MumfordAg]

additional information:
using excel 2007
17 variables in worksheet containing data that is being summarized, 500 rows
using 7 of those variables in pivot
3 levels of subtotals on 7 variables in pivot with 2 column groupings
computer memory appears adequate

thanks for any additional insight.