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?

Thank you in advance for your assistance!

 

 

excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Nov 30, 2024

    As variant that could be misprint like

    if you enter, for example, colon instead of point. Above is simplest case, could be similar. If you have Inquire in your version of Excel, try to check workbook with it and revise found array formulae.

     

  • 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