Close Unnecessary Apps Running in The Background

1. Simply press the CTRL + ALT + DEL together >> click on the Task Manager.
2. Next, click Processes tab & search for the unnecessary processes.
3. Once you have found it, right-click on that process >> select the End Task.
4. Now, restart MS Excel to check if the error is fixed.

Rectify Incorrect Formula

An improper formula in the cell is the foremost reason for Excel ran out of resources error. Though you can easily fix it by verifying the formula that you have inserted into the cells. To find out the incorrect formula, you can simply look for the exclamation mark over the cell, that has some glitches with the formula. If the entered formula seems incorrect, then correct it.

Run the Excel Compatibility Mode

1. Open MS Excel >> go to the File menu >> Choose Info 
2. Next, click on a Downward arrow in a Check for Issues
3. There, choose Check Accessibility and select the compulsory version
4. At last, click Ok button

Limit the Number of Processors

1. Open the MS Excel document that is showing the error
2. Go to the File >> click on the More option
3. After this, choose the Options
4. Under Excel Options, you have to click on an Advanced tab
5. Now, scroll down to Formulas section
6. Here, tick a Manual option and set number of processors to 1
7. Lastly, click on the Ok.

Use Open & Repair Utility

1. In MS Excel, click on File tab >> click Open
2. Then, click on Browse option to select a corrupted file
3. After this, in the Open dialog box, click on a specific file or all files that are corrupted
4. At this time, click on the arrow next to an Open button >> click on Open and Repair
5. You will get a dialog box, click on a Repair
6. Once the file is repaired successfully, a message will seem (as shown below)
7. Finally, click Close and check for the issue.

Repair MS Office to Fix Excel Ran Out of Resources While Attempting to Calculate

1. Initially, right-click on a Start menu >> Go to the installed Apps or Apps & Features (Windows 10)
2. Find the Microsoft 365 or Microsoft Office 365
3. Next, click on the More option next to the located app & pick Modify >> Click Yes
4. On the Microsoft Windows, you have to choose Quick Repair & click on the Repair
5. Again, click on Repair button to confirm.

Disable the Excel’s Multi-threaded Calculation 

1. In Excel, go to the File >> click on the More option
2. After this, choose the Options
3. Under Excel Options, you have to click on an Advanced tab
4. Then, scroll down to Formulas section and untick the Enable multi-threaded calculation  This will disable this feature & click OK.