+ Reply to Thread
Results 1 to 4 of 4

Pivot Table Calculated Item - Too Many Records

  1. #1
    Registered User
    Join Date
    03-15-2011
    Location
    92821
    MS-Off Ver
    Excel 2003
    Posts
    12

    Pivot Table Calculated Item - Too Many Records

    I'm trying to enter a variance column to compare data from April versus May. I figured out how to calculate the data by using Pivot Table Tools > Options > Formulas > Calculated Item. However, after I enter the formula, I get a pop-up error that says "There are too many records to complete this operation."

    The pivot table is 185 rows and the source table is 473 rows. It doesn't seem like the table is so large that Excel wouldn't be able to handle calculating the data. Any ideas on what could be going wrong?

    -K

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,513

    Re: Pivot Table Calculated Item - Too Many Records

    Hi Kareni,

    I wonder if you have a minimum amount of memory and a lot of shapes or other objects in your excel file. The number of rows seems small enough but other things can be using lots of memory and cloging things up. Do you have any VBA code? Do you have any Volitile formulas on other sheets or in the same sheet?

    Can you try your work using a 2007 version of excel? That might give you a clue on memory issues.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-15-2011
    Location
    92821
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Pivot Table Calculated Item - Too Many Records

    I'm currently using 2007 Excel. There are many other sheets in the file but no VBA code. There is another pivot table but it's very small (13 rows). Is there a way to troubleshoot where the memory issue is coming from with 2007 Excel?

    Thanks,
    K

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,513

    Re: Pivot Table Calculated Item - Too Many Records

    I'd try a few things to determine what is causing the problem.

    I'd create the new pivot on a new sheet to see if that works instead of where you are trying to put it.
    I'd try to copy the data, values only, to a new workbook and do your pivot on that data to see if it works.

    Somewhere along the line you are hoping to find what works and run into a setting or property that is giving the error message. Something simple like trying to put both pivot tables in the same space may be the problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1