Forum Discussion

rafaelcilios's avatar
rafaelcilios
Copper Contributor
Nov 30, 2024

Ran out of Resources

Hi Team, I’m encountering an error in my spreadsheet that I’ve tried several ways to resolve, but without success. Could anyone help me understand what might be causing this issue and suggest a fix?...
excel
Kidd_Ip's avatar
Kidd_Ip
MVP
Nov 30, 2024

Try this:

 

  • Check for Complex Formulas: Ensure that your formulas are not overly complex or referencing excessively large ranges. For example, avoid formulas like =A:GZ or =D762:DD764811:D770.
  • Disable Hardware Graphics Acceleration: Go to File > Options > Advanced > Display and disable hardware graphics acceleration.
  • Reduce the Number of Processors: Go to File > Options > Advanced > Formulas and set the number of calculation threads to 1.
  • Check for Circular References: Ensure there are no circular references in your workbook.
  • Simplify Your Workbook: If possible, reduce the number of sheets and datasets in your workbook.
  • Update Excel: Make sure you're using the latest version of Excel.
  • Run Excel in Compatibility Mode: Sometimes running Excel in compatibility mode can help.

Resources