Closed Thread
Results 1 to 2 of 2

Resource issue with Pivot Table Excel 2010

  1. #1
    Forum Contributor
    Join Date
    06-11-2018
    Location
    Lebanon, NH
    MS-Off Ver
    2000 and 2010
    Posts
    106

    Resource issue with Pivot Table Excel 2010

    Working on a project to automate much of the current estimating process for new homes. This project will require me to handle large files, some in excess of 57000 rows, the smallest in the vicinity of 10000 rows. When I parse the data down to 10000 rows I am within the limits of pivot tables. I am able to create the pivot table but as soon as I try to set up row and column labels the entire PC freezes. Eventually I get a popup error stating "Excel cannot complete this task with available resources. Choose less data or close other applications." If I click OK I get a second popup window stating "Not enough system resources to display completely." I have done a cold boot of the PC, started nothing but Excel and my results are the same. Nothing is set to start at startup. The PC has 8gb of memory. Is it likely this is truly a resource issue or is the message indicative of a different problem?
    Thanks much
    Bill
    Last edited by billfinnjr; 06-11-2018 at 09:45 AM.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Resource issue with Pivot Table Excel 2010

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    https://www.excelforum.com/excel-cha...resources.html

    Thread Closed.

Closed 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