A lot of users find Microsoft Excel as one of the most useful Office applications they have on their computers and mobile devices. It enables them to organize information and data into a more presentable view while helping with more accurate calculations. MS Excel has formulas that you can use when calculating various data sets, so it is more precise than doing it manually.
Unfortunately, there comes a time when you may encounter problems while working on your Excel spreadsheet files. You may see the error message, “Excel ran out of resources while attempting to calculate one or more formulas.”
For many users, it is worrisome to experience an issue when working on your Excel worksheet. But, errors happen for a reason and can be resolved with proper troubleshooting help.
How to Troubleshoot & Fix “Excel ran out of resources while attempting to calculate one or more formulas” Issue
Microsoft Excel ran out of resources if there are incorrect formulas on the cells. If you add the wrong formula, or in some cases with circular references, Excel will stop calculating it and trigger the error message.
Solution #1 – Check your Formula
Excel will show an exclamation mark on the cell with the incorrect formula. You can check if there are wrong values in it. You can retype the formula manually to double-check. Make sure that you are only including cells with values in them.
Another way is to use the Trace Error. On the menu car, navigate to the Formula tab. Select Error Checking and click Trace Error.
Solution #2 – Run the Compatibility Mode when using Excel
- On your Excel, click the File tab.
- Go to Info.
- Look for the Check for Issues option and click the Down Arrow next to it.
- Select Check Compatibility.
- Choose a different version.
- Click OK.
Solution #3 – Reduce the Number of Processors Used
- Navigate to the File tab on Excel.
- Scroll down and select More.
- Click Options.
- Go to the Advanced tab.
- Navigate to the Formulas section.
- Look for the Number of calculation threads.
- Tick the Manual button.
- Now, set the number of processors to 1.
- Click OK.
What solution helped you fix the Excel error related to formulas on your worksheet cells? We would love to know what works. You can share your answers below.