Become The Solution Chicago Logo

Become The Solution Chicago Logo

Search Become The Solution:

Fix: Excel Ran Out of Resources While Attempting To Calculate One or More Formulas

Fix: Excel Ran Out of Resources While Attempting To Calculate One or More Formulas

You receive a pop-up message in Microsoft Excel when you open an Excel workbook containing formulas and calculations.

 

Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated.

 

It appears Hyper Threading causes Excel to produce this error even if your workbook is small. The easiest solution however is not to disable hyper threading, but to reduce the number of parallel cores Excel is using when you have the workbook open.

 

  1. While Microsoft Excel is open, open Windows Task manager.
 
  1. In Windows Task manager, select Processes tab and find EXCEL.EXE*32 -> right-click and choose Set Affinity…
 
Windows task manager set affinity
 
  1. Finally, de-select <All Processors> and select one CPU core and click OK.
 
Windows processor set affinity
 

Test your Excel Workbook after you make the change. You can continue to add cores to Excel this way if you need additional performance, but be aware adding more cores may bring back the error message.

 


Related Posts

 

Comments

Michael on Monday, 22 November 2021 11:51

I experimented unsuccessfully with all that "Core" selecting mentioned above. As it turned out, I had a bad formula!!! CHECK YOUR FORMULAS! For example, I had this vlookup formula: VLOOKUP(Cell,Range,Column,False), ...except that I forgot to type in the "Cell". This made Excel not know where to look first which essentially created an endless search. I found the bad formula, and it's all good again.

I experimented unsuccessfully with all that "Core" selecting mentioned above. As it turned out, I had a bad formula!!! CHECK YOUR FORMULAS! For example, I had this vlookup formula: VLOOKUP(Cell,Range,Column,False), ...except that I forgot to type in the "Cell". This made Excel not know where to look first which essentially created an endless search. I found the bad formula, and it's all good again.
Elvy on Thursday, 17 June 2021 20:41

Yey!. it works for me too. thanks a lot

Yey!. it works for me too. thanks a lot :)
Melissa Madden on Thursday, 21 January 2021 13:57

Fixed- Thank you SO much!!

Fixed- Thank you SO much!!
Lynn on Monday, 18 January 2021 15:30

"Set Affinity" was under Details tab, not Processes. However, the suggested solution did not resolve the issue for me.

"Set Affinity" was under Details tab, not Processes. However, the suggested solution did not resolve the issue for me.
Tri Nguyen on Tuesday, 03 November 2020 23:33

My laptop doesnot exit "Set Affinity" when I right click !

My laptop doesnot exit "Set Affinity" when I right click !
Rick on Saturday, 24 October 2020 14:33

I tried to reload Office 360 which turn out to be a disaster. It would not reload. I contact Microsoft
support and after long hours. My Office reload. The error message went away. Now 2 days later I am back to the same problem.

I tried to reload Office 360 which turn out to be a disaster. It would not reload. I contact Microsoft support and after long hours. My Office reload. The error message went away. Now 2 days later I am back to the same problem.
Russell J Scanlon on Tuesday, 11 August 2020 22:49

Hope this thread is still active! Getting same error msg. I NO formulas, I've tried diabling HT, tried reducing cores through Task Manager as suggested, nothing gets rid of the msg. Tried Copying the sheet to a new workbook but error appears. Even saving a new BLANK workbook produces the error.
All this seems to have started when I upgraded my Office subscription to a family level (not sure why that would make a difference)
Any suggestions?

Hope this thread is still active! Getting same error msg. I NO formulas, I've tried diabling HT, tried reducing cores through Task Manager as suggested, nothing gets rid of the msg. Tried Copying the sheet to a new workbook but error appears. Even saving a new BLANK workbook produces the error. All this seems to have started when I upgraded my Office subscription to a family level (not sure why that would make a difference) Any suggestions?
inam on Tuesday, 14 May 2019 04:33

still not resolved
(Fix: Excel Ran Out of Resources While Attempting To Calculate One or More Formulas)

still not resolved (Fix: Excel Ran Out of Resources While Attempting To Calculate One or More Formulas)
Jeff Cheong on Thursday, 13 December 2018 17:08

It works for me. Thanks for the tip. BTW I am running an i7 8 core machine. The vintage of the machine is ~ 2013. The problem was solved once I followed the tip, I reduced the nos. of CPU to only 1 (instead of all 8 cores) to run Excel

It works for me. Thanks for the tip. BTW I am running an i7 8 core machine. The vintage of the machine is ~ 2013. The problem was solved once I followed the tip, I reduced the nos. of CPU to only 1 (instead of all 8 cores) to run Excel
Guest
Wednesday, 10 August 2022