Lỗi excel not enough available memory or disk space năm 2024
Is Microsoft Excel struggling to use enough memory to run? Here's how to fix this error message on Windows. Show
Microsoft Excel is an excellent program for managing data in a spreadsheet. But this doesn't mean the program is free from problems. One of the issues that have been in the talk lately is the low memory prompt that appears on opening, saving, and editing Excel documents. The error isn't version specific, i.e., it can appear on all the Microsoft Excel versions. Fortunately, it's a cakewalk to get rid of this problem. Just try the below solutions to eliminate the issue for good. What Causes the "Not Enough Memory To Run Microsoft Excel" Error?Microsoft Excel mainly throws the low memory prompt when you try to open a file larger than two gigabytes. But unfortunately, this isn't the only cause. The problem can also appear due to the following reasons.
Now that you know the primary culprits behind the error, let's check out all the working fixes. 1. Close Any Non-Essential Background ApplicationsLet's start with the most obvious solution by doing as the error prompt asks you to do. When Microsoft Excel runs out of memory, the error message appears with this message: "Not enough memory to run Microsoft Excel. Please close other applications and try again." As per the error message, try closing other background running applications that aren't necessary for your PC to run. You can do it by following the below steps.
Try to open Microsoft Excel again and check if the problem continues. 2. Run Microsoft Excel With Administrative RightsThe error can appear if you are running Microsoft Excel without administrative rights. As a solution, always run the program as an administrator. Here's how to do it.
Check if you are still facing the problem. 3. Download the Latest Windows UpdateThe outdated Windows version is another prime reason behind the problem at hand. Each Windows update comes along with new features and bug fixes. So, consider downloading the latest Windows update to fix the Excel low memory issue. Here's how.
Windows will search for and download the available update. Once the update process is complete, reboot the system and check for the problem. 4. Update Microsoft OfficeThe next solution on the list is downloading the latest Microsoft Office update. You can do that by following the below steps.
Microsoft Office will look for any available update. If any update is found, save and close any pending task to begin the update process. 5 . Repair Microsoft OfficeThe problem can result from a temporary glitch or minor bug in Microsoft Office. You can get rid of this bug by using the repair feature. Here's what you need to do.
6. Disable CortanaWindows official digital assistant Cortana is another significant reason why you are facing the problem. As a solution, you'll have to disable Cortana. Below are the steps to turn off Cortana on Windows 11.
Reboot the system, launch Excel and check if the problem persists. 7. Open Excel in Safe ModeDifferent add-ins installed on Microsoft Excel can be the culprit behind the problem. To find out which particular add-in is causing the issue, launch Excel in Safe mode and check if the problem is fixed or not. If yes, relaunch Excel and disable each add-in one by one until the problem goes away. Once that happens, the add-in you just disabled is highly likely to be the cause of the error. Here are the exact steps you need to follow.
Repeat the steps with each add-in. Once you find the culprit, remove it from Microsoft Excel. 8. Change the Trust Center SettingsIf the problem in the question appears on opening an excel file from an email client, the Trust Centre setting is probably behind the problem. You'll have to change the Trust Center to resolve the issue. Here's how.
Check if the problem is fixed or not. 9. Change the Dynamic Data Exchange SettingsIf you still face the problem, consider changing the Dynamic Data Exchange (DDE) settings in Microsoft Excel. Here's how.
Manage Excel Files With EaseHopefully, the above solutions helped resolve the issue. But if you still face the problem, consider reinstalling Microsoft Office. |