Pivot Table Error - Too Many Records

when trying to add a row field to a pivot table I'm receiving an error message indicating "too many records to complete this operation.  The pivot is not that large (results only a few hundred rows...any idea why this is happening and how to fix it?

The data is being pulled from an Access Query.

Proprietary info so I cannot attach the file...sorry.
marquestAsked:
Who is Participating?
 
sameer2010Commented:
This one for Excel 2003:
http://support.microsoft.com/kb/820742
0
 
sameer2010Commented:
Please refer this:
http://office.microsoft.com/en-us/excel/HP100738491033.aspx#PivotTable

You must have exceeded one of these.
0
 
marquestAuthor Commented:
Thanks for the help...it turned out to be something related to a calculated field...once I deleted the calced field it appears that it is working.
0
 
sameer2010Commented:
Yes. Because PIVOT takes into account calculated field rowset as well while checking the limits.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.