Q: My Excel Shows "Not Enough Memory""Hello. Whenever I click on my Excel, I keep getting this message: "Not enough memory khổng lồ run Microsoft Excel. Please close other applications and try again". I have done that but the error persists. Please, what bởi I do?!"
SUMMARY
Microsoft Excel tends to experience memory issues more often than you think, such as " there isnt enough memory to lớn complete this action Excel", "not enough memory khổng lồ run Microsoft Excel", etc. So, vị not be shocked when you see the memory error message on your screen while you are trying to lớn work with, or save, files lớn your Excel.
Bạn đang xem: How to troubleshoot available resources errors in excel
This article will show you the symptoms of this error and the different causes (to prevent the error from occurring in the future). Also, you will be given various solutions khổng lồ try in getting rid of the error message, as well as comprehensive steps on how to lớn fix any corrupt Excel tệp tin that may result from this error.
In this article
01 Part 1: Excel Not Enough Memory Symptoms và Causes
02 Part 2: How lớn Repair Excel tệp tin Corrupted/ Damaged by Various Reasons
03 Part 3: How to lớn Avoid và Fix the "Excel Not Enough Memory" Error?
04 Part 4: Other Common Excel Issues You May Encounter
Part 1: Excel Not Enough Memory Symptoms và Causes
For computer users, you may encounter any of the following error messages while working with a file on Microsoft Excel:
Excel cannot complete this task with available resources. Choose less data or close other applications.
Out of Memory
Not enough System Resources to Display Completely
There isn"t enough memory khổng lồ complete this action. Try using less data or closing other applications. To increase memory availability, consider:-Using a 64-bit version of Microsoft Excel.-Adding memory lớn your device.
If you have encountered any of these messages, then it"s time lớn get full information on the causes và solutions. You may think you have it all figured out from the instructions in the error messages but these don"t always reveal the real cause of the problem because of their generic nature.
But if you keep seeing the error while performing any of the functions below, then it is time to figure out what is happening within your file:
Sorting
Copy & pasting
Running VBA
Inserting a row or column
Opening or closing your workbook
Performing calculations
Trying lớn delete a single row in an excel sheet
The causes of Excel Not Enough Memory error include:
1. Trying to lớn Copy Formulas over A Large Area: If your Excel file is large or contains many features, your memory resources may just be running low. Thus, you are most likely lớn receive these error messages when trying to copy or fill formulas into a large area on your worksheet. The Excel versions (Excel 2007, 2010, 2013, & so on) 32-bit is limited because of the setting khổng lồ 2GB (or 32,760 source cells in cases where you use a smart fill option) so trying lớn work with large sections of the worksheet will only trigger this error.
2. Problems with Calculations: The error might be related to lớn a recalculation of formulas when you insert rows and columns, copy và paste or perform calculations. For instance, say your spreadsheet contains a million formulas on a sheet, then you insert another column. Of course, Excel will have to recalculate all the formulas in your spreadsheet to lớn make adjustments for the newly inserted column. In this case, you may receive the error message "out of resources" depending on how complex your spreadsheet is, the bit capacity of your Excel, what formulas are involved, and how your spreadsheet is built.
3. Other Elements of Spreadsheet: There are other areas of Spreadsheets that can cause Excel memory errors such as complex Pivot
Tables, excess shapes, macros, complex charts with many data points, and so on. Thus, your computer may have enough space in its local memory but excel will show "Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space". Issues like this are related to lớn the security settings innate in Excel 2013 or Excel 2016.
4. Other Applications: Another cause of the excel memory error may be that the other applications on your PC are taking up the bulk of your computer memory thereby leaving Excel not enough memory khổng lồ complete action.
Recent Videos from repairit: How khổng lồ Fix Excel Not Enough Memory?
View More >
Use the following simple steps to repair you are corrupted or damaged Excel and also, repair your data:
First, download and install Wondershare Repairit, then launch the software.
On the home screen, choose the corrupt Excel tệp tin you wish khổng lồ repair by clicking "Add".
Second, Select "Repair" to lớn start the repair process.
After repairing, you will see a display of all the repairable items on the left-hand panel of the software"s interface. Double-click any thành tích here khổng lồ preview it.
Finally, if you are satisfied with the result, select the "Save" option from the main menu to save the file that has been repaired.
You will be prompted lớn provide the destination you desire to save the file, select "OK"
Afterward, an appropriate message to save the work will pop up on the screen.
Try It Free
Perform the Selection of Cells Gradually: First select just the part that needs filling from the whole range of the spreadsheet before you vị the same for the next section of cells and continuously, one at a time. Khổng lồ avoid reaching the limitations of your Excel, select on the last row of the section you previously filled before moving on to lớn the second, the third segments, và so on until you reach the kết thúc of your selection.
Separate your Excel file into different workbooks: Here, you can split up the large Excel file you are working with into different separate workbooks before going ahead to xuất hiện each one in a different instance of Excel from the other lớn avoid complications that come from working with large files. By implication, each of these workbooks you xuất hiện will use 2GB as its memory limitation so you get to lớn avoid reaching the memory limitation of 2GB placed on Excel. To vày this with the Move or Copy feature, follow these steps:
1) Choose the sheets from the Sheet tab. Right-click và choose "Move or Copy" from the menu that pops up. You can choose several non-adjacent sheets by holding down the "Ctrl" key & clicking them one after the other. You can also choose several adjacent sheets by holding down the "Shift" key on your keyboard và selecting the first và last options on the Sheet tab.
2) In the pop-up window "Move or Copy" window, opt for "(new book)" below the "To book" list. Tick the option that says "Create a copy". Then choose "OK".
3) Your selected sheets have now been moved to a new workbook. Click on "File". Select "Save" to save your new book.
Use F10 Instead of F9 to lớn Refresh Worksheets: You can refresh your Excel inside the Controller Excel link using either F9 or F10 but there is a difference between using either function. Using F9 will refresh all the sheets inside the whole spreadsheet file while using F10 will only refresh the sheet you are currently on. However, in cases where the current sheet has formulae referenced in the other sheets in the whole workbook, using F10 will refresh those sheets that contain the formulae. Use F10 to lớn refresh because it is significantly faster than F9 in fetching values from your database. F9 is slower because it works with the entire worksheet at the same time, no matter the large size. Therefore, F10 is the best key to lớn use for specialized or complex spreadsheets.
Use manual calculation in the Excel-link workbook: This option works for solving the memory error that arises when your Excel has to recalculate and adjust the entire workbook each time you introduce new values in the worksheet. Khổng lồ manually recalculate within the workbook in Excel, follow these steps:
1) Select the "File" tab
2) Click on "Options" from the các mục provided on the left side of the screen
3) The "Excel Options" window will appear. Select "Formulas" from the các mục of options, also on the left.
4) Select the "Manual" radio button which is found in the "Calculation options" section. This automatically turns on the ability of Excel lớn engage in the manual calculation in the worksheets. Choose "Manual" to make for automatic checking of the box "Recalculate workbook before saving". This option is important if you save worksheets frequently và do not want to wait khổng lồ recalculate each time you vày so. Choosing the "Recalculate workbook before saving" will ensure that the option is not disabled.
If you don"t mind the option of "Recalculate workbook before saving" getting enabled as soon as manual calculation is turned on, then use this faster method lớn recalculate your worksheets manually:
1) Select "Formulas"
2) From the "Calculations Options" drop-down list, choose "Manual"
3) Click the "Calculate Sheet" options in the Calculation section or press "Shift" và "F9" keys together on your keyboard and the current worksheet you are working with will manually recalculate.
Video tutorial: There isn’t Enough Memory khổng lồ Complete this kích hoạt in MS Excel
Recent Videos from repairit
View More >Part 4: Other Common Excel Issues You May Encounter
Below are some of the common errors you may encounter as you use Excel, in addition to the already-discussed Excel memory error:
1. "There was a problem connecting to lớn the hệ thống Excel" error: This error message shows up when Excel and Windows Share
Point Services prevent the spreadsheet from getting correctly imported into Windows Share
Point. You can fix this problem by creating a new list that is based on your Excel workbook, changing the Site Settings, và using a ULS Viewer downloaded from Microsoft"s official website.
2. "There"s a problem with this formula": This error is usually experienced in some Windows ten by users on their Excel. When trying to lớn use a formula lớn make several different calculations, this error may prevent the function from happening. To fix this error, you can: make use of system separators, kiểm tra the regional settings of your system, & change the correct spelling settings.
3. "Excel Online won"t calculate/won"t open": The large worksheets (big grids of rows và columns) & different parts that compose the Excel application slows down the calculation and analysis of data tasks. Therefore, this error is related lớn these tasks, as well as the kích cỡ of the tệp tin you are using. Other factors at play include multithreaded calculation và the design và build of your worksheet. You can fix the problems with your Excel Online using these solutions: examine the formulas you use, open your workbook in Excel"s latest version, calculate across different workbooks, as well as limit the use of volatile functions.
If you see Not enough memory to lớn run Microsoft Excel error while launching Excel, then the solutions provided in this article may help you fix it. This error prevents users from working in Microsoft Excel because they can’t xuất hiện any spreadsheet. Some users have seen this error while attaching an Excel file in Microsoft Outlook or while opening an Excel tệp tin from Outlook và from another email client.
There might be some problematic add-ins in Excel that are causing the problem. To check this, you have lớn troubleshoot Excel in Safe Mode. Check if you are able lớn launch Excel in Safe Mode. If yes, some of your Add-ins are the culprit.To launch Excel in Safe Mode, xuất hiện the Run command box and type excel /safe. After that, click OK. This will mở cửa Excel in Safe Mode. Now follow the steps below:Go to lớn “File > Options.”Select Add-Ins from the left side.Click on the Manage drop-down và select COM Add-ins. Click Go.Deselect anyone add-in lớn disable it and click OK.Close Excel in Safe Mode and launch Excel in normal mode. See if the issue appears. If yes, repeat the above steps to disable another add-in và then launch Excel in normal mode again.The above steps will help you find the problematic add-in. Once you find it, remove it from Excel.5> Troubleshoot in a Clean Boot state
If there is no problematic add-in in Excel, the issue might occur due to lớn a conflicting background or startup app. You can easily identify that program by starting your computer in a Clean Boot state. After starting your computer in a Clean Boot state, launch Microsoft Excel và see if the “Not enough memory khổng lồ run Microsoft Excel” message appears. If not, there is a program that is conflicting with Microsoft Excel due to lớn which Excel is displaying this error.To identify that program, enable some of the disabled programs in the Clean Boot state, và then start your computer in a normal state. Launch Excel after starting your computer in the normal state & see if the error occurs. If yes, some of the programs you have just enabled are causing the problem. Khổng lồ identify those programs, disable the enabled programs one by one & launch Excel each time you disable a program. This will help you identify the problematic startup application.
Xem thêm: Hướng dẫn 3 cách thay đổi gói cước 3g viettel, cách chuyển gói cước viettel miễn phí mới nhất
Related: Excel is slow to respond or stops working6> Change the Trust Center settings
If you are unable to lớn attach an Excel in Outlook or if you are getting the error message after opening the Excel tệp tin from Outlook or another email client, change the Trust Center settings và see if it works.
