?
Solved

Pivot Table Error - Too Many Records

Posted on 2009-12-29
4
Medium Priority
?
891 Views
Last Modified: 2012-05-08
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.
0
Comment
Question by:marquest
  • 3
4 Comments
 
LVL 13

Expert Comment

by:sameer2010
ID: 26137428
Please refer this:
http://office.microsoft.com/en-us/excel/HP100738491033.aspx#PivotTable

You must have exceeded one of these.
0
 
LVL 13

Accepted Solution

by:
sameer2010 earned 2000 total points
ID: 26137431
This one for Excel 2003:
http://support.microsoft.com/kb/820742
0
 

Author Comment

by:marquest
ID: 26137449
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
 
LVL 13

Expert Comment

by:sameer2010
ID: 26137460
Yes. Because PIVOT takes into account calculated field rowset as well while checking the limits.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question