+ Reply to Thread
Results 1 to 8 of 8

Error - "There isn't enough memory to complete this action."

  1. 07-09-2022, 02:00 PM #1
    artiststevens
    artiststevens is offline
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Question Error - "There isn't enough memory to complete this action."

    Hello,
    I am getting the following error when opening files larger than 1GB in Excel.

    "There isn't enough memory to complete this action. Try using less data or closing other applications."

    My system had no issues with opening files of this size before until today.


    MY SYSTEM:
    Processor Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz 3.40 GHz
    Installed RAM 32.0 GB (31.9 GB usable)
    System type 64-bit operating system, x64-based processor
    Microsoft® Excel® for Microsoft 365 MSO (Version 2206 Build 16.0.15330.20216) 64-bit


    I have already done the following:
    The file is set to manual calculation.
    Ignore other apps using DDE is checked
    Unchecked Trust Center settings
    Ran Quick Repair and Online Repair

    Any help would be greatly appreciated. Thank you.
    Attached Images Attached Images
    Last edited by artiststevens; 07-12-2022 at 04:32 AM.
    Reply With QuoteRegister To Reply
  2. 07-09-2022, 02:13 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,004

    Re: Error - "There isn't enough memory to complete this action."

    Can you actually OPEN the file but not do calculations? If you can't open the file, how did you carry out those actions?


    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 07-09-2022, 02:25 PM #3
    artiststevens
    artiststevens is offline
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Re: Error - "There isn't enough memory to complete this action."

    Thank you for the reply. I am unable to OPEN the file at all. It's not only one file. It's any file that is 1GB or higher in size. I am unable to attach it as well due to the size of the file being the issue.
    Reply With QuoteRegister To Reply
  4. 07-09-2022, 05:36 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,004

    Re: Error - "There isn't enough memory to complete this action."

    1 Gb is quite a big file. That said, in theory, 2 Gb is the maximum size for 32 bit version of Excel.

    What makes the file so big?

    Maybe try opening the file in Libre Office ( https://www.libreoffice.org/ ) and see if there is anything untoward.
    Reply With QuoteRegister To Reply
  5. 07-11-2022, 06:53 PM #5
    artiststevens
    artiststevens is offline
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Re: Error - "There isn't enough memory to complete this action."

    Thank you again for the help.

    I'm using the 64 bit version and have opened the document several times in the past.

    A lot of data and formulas. I should of restructured it when I had the chance.

    Tried opening it in Libre Office and it doesn't open give any errors. Pushes my system's memory usage to 100% and keeps loading.
    Reply With QuoteRegister To Reply
  6. 07-12-2022, 04:31 AM #6
    artiststevens
    artiststevens is offline
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Re: Error - "There isn't enough memory to complete this action."

    Thank you for the help TMS. I finally figured out the problem. Microsoft released a new 365 version on July 6th - right about the time my problem started! (2206 build 16.0.15330.20230) - After some research, figured out how to use the Office Deployment Tool to roll back to the previous 365 version 2205 build 16.0.15225.20204 and no more memory errors.
    Reply With QuoteRegister To Reply
  7. 07-12-2022, 05:35 AM #7
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,004

    Re: Error - "There isn't enough memory to complete this action."

    You're welcome. Thanks for the rep.


    Glad you worked it out. Guess we couldn't go there for you.
    Reply With QuoteRegister To Reply
  8. 07-12-2022, 11:28 AM #8
    chenxin
    chenxin is offline
    Registered User
    Join Date
    06-29-2022
    Location
    china
    MS-Off Ver
    2010,2019
    Posts
    16

    Re: Error - "There isn't enough memory to complete this action."

    it's not strange. some much smaller files will get this alarm too. they are with size of only a few KB. it may contain too much styles or you may disabled virtual memory (because you are proud of you large size of memory).
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code causes error: “There isn't enough memory to complete this action.”
    By dubumochi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2019, 07:30 AM
  2. Excel 2013 "not enough memory to complete action"
    By ccruse in forum Excel General
    Replies: 4
    Last Post: 12-16-2015, 11:29 AM
  3. how to solve error as "excel is waiting for another app to complete an ole action"
    By bhuvana86 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2015, 12:38 PM
  4. There isn't enough memory to complete this action.
    By matrix2280 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-18-2015, 12:51 PM
  5. There isn"t enough memory to complete this action
    By Tyso in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2015, 01:31 AM
  6. [SOLVED] "not enough memory" error on workbook.save , but not .close(SaveChanges:=True)
    By sylvainsylvain in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-18-2013, 12:08 PM
  7. "Not Enough memory to display" error when dropdown values in combo are selected
    By pabs1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2012, 02:49 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1