<div>
Please refer this:<br />
<a href="http://office.microsoft.com/en-us/excel/HP100738491033.aspx#PivotTable" rel="ugc">http://office.microsoft.com/en-us/excel/HP100738491033.aspx#PivotTable</a><br />
<br />
You must have exceeded one of these.
</div>


Please refer this:
http://office.microsoft.com/en-us/excel/HP100738491033.aspx#PivotTable [http://office.microsoft.com/en-us/excel/HP100738491033.aspx#PivotTable]

You must have exceeded one of these.

<div>
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.
</div>


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.

<div>
Yes. Because PIVOT takes into account calculated field rowset as well while checking the limits.
</div>


Yes. Because PIVOT takes into account calculated field rowset as well while checking the limits.

<div>
<div class="content wysiwyg-content">
when trying to add a row field to a pivot table I'm receiving an error message indicating &quot;too many records to complete this operation. &nbsp;The pivot is not that large (results only a few hundred rows...any idea why this is happening and how to fix it?<br />
<br />
The data is being pulled from an Access Query.<br />
<br />
Proprietary info so I cannot attach the file...sorry.
</div>
</div>


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.

Pivot Table Error - Too Many Records

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.