Not Enough Memory Upon File Open Excel Proplus

wookinpunub 1 Reputation point
2020-12-16T18:15:15.707+00:00

File worked fine yesterday and when I went to open it today it just kept shutting down on me just as soon as it would open. I finally got it to open and then I received the error that there was not enough memory to process and I needed to shut down other applications and free up resources. The file does not have any external links but what I figured out is that it would shut down when it started calculating. So I opened up a new excel workbook and change to manually calculate data. Then opened that file back up and it did not shut down and stayed open this time. I do not have any heavy calculations in this workbook at all. So I saved a copy of the file and changed it to a zip file and opened it up. then looked at the worsheet sizes Sheet1 showed 42MB and I don't see how that is, it has 7,155 rows of data without any formulas and goes to column OJ which leads me back to previous forum posts where I have issues with Excel workbooks is when the data columns exceed the 250 column threashold and I have it set as Table. My PC is very powerful and capable of handling huge work books. I have already checked for blank unused cells and that is not an issue. Is sheet1 when viewed from zip file the first sheet in the Excel file or is it the file listed as Sheet1 in the VBA Editor? Either way both of those sheets should not be 42MB in size unless the columns are causing that.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Emi Zhang-MSFT 21,706 Reputation points Microsoft Vendor
    2020-12-17T08:42:01.97+00:00

    Hi @wookinpunub ,

    Where did you store the file? In local or network?
    Did you check if only this file face this problem?
    I suggest you refer to this support article and try the methods:
    https://learn.microsoft.com/en-us/office/troubleshoot/excel/available-resources-errors

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. wookinpunub 1 Reputation point
    2020-12-22T14:51:58.44+00:00

    I was able to fix my issue by opening the workbook in Safe Mode and then removing some formulas that referenced a linked file. I removed the linked file all together, saved the workbook and upon re-opening it worked much better. None of the steps in the article were able to fix my issue. I do appreciate your support and time spent helping me. Hope you have the best holiday ever.