+ Reply to Thread
Results 1 to 4 of 4

Not enough resources error

  1. #1
    Registered User
    Join Date
    05-02-2017
    Location
    Rome, NY
    MS-Off Ver
    2010
    Posts
    2

    Not enough resources error

    Hello everyone,
    My first post
    on a a particular file I open I get a error of not enough resources to complete task, choose less data or close other apps. The file is not overly large but has 200 sheets and is used for tracking spending I can open any other excel file without issue. suggestions appreciated.

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Not enough resources error

    200 sheets is quite a few more than the 'typical' excel file however the number of sheets itself won't be causing the issue.

    The amount of cells contains data will add to the file size, however any formulas in the file will refresh each time you open and this can be an exhaustive task.

  3. #3
    Registered User
    Join Date
    05-02-2017
    Location
    Rome, NY
    MS-Off Ver
    2010
    Posts
    2

    Re: Not enough resources error

    So am I to live with it? Is there a setting that can be changed to help this issue?

  4. #4
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Not enough resources error

    You can look to make your file leaner by improving formulas and functions or reducing the amount of content, or you can get more memory or you can upload a file and see if anyone is happy to help tidy it up for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 05-31-2015, 12:53 PM
  2. Error Message - Large Operation - available resources?
    By MarvinP in forum Tips and Tutorials
    Replies: 2
    Last Post: 12-04-2013, 07:25 PM
  3. Replies: 4
    Last Post: 05-10-2013, 12:45 PM
  4. not Enough Resources error
    By milton friedman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2013, 09:56 AM
  5. available resources error message
    By stephenGaddy in forum Excel General
    Replies: 1
    Last Post: 12-11-2009, 03:49 AM
  6. Excel 2007 : Error - Excel has run out of resources!
    By rikkiholland in forum Excel General
    Replies: 7
    Last Post: 09-22-2009, 04:27 AM
  7. [SOLVED] error: Not enough system resources to display completely
    By Rich in forum Excel General
    Replies: 1
    Last Post: 02-27-2006, 09:10 PM

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