how solve this problem

moo gomaa 0 Reputation points
2026-07-08T09:29:29.5566667+00:00

Screenshot 2026-07-06 133859

how solve this problem

Microsoft 365 and Office | Excel | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jayden-P 25,690 Reputation points Microsoft External Staff Moderator
    2026-07-08T09:59:09.6333333+00:00

    Hi @moo gomaa

    This error typically occurs when Excel's calculation engine runs out of available memory or becomes overwhelmed by complex formulas and calculations. Please verify the following things:

    1. Check whether you are using 32-bit or 64-bit Excel

    Open Excel and go to File > Account > About Excel.

    At the top of the About window, confirm whether Excel is 32-bit or 64-bit.

    1. Review formulas that reference entire columns

    Please check whether any formulas reference full columns (for example, A:A, B:B, etc.).

    Functions such as XLOOKUP, SUMPRODUCT, array formulas, and other calculation-intensive formulas can consume significant resources when applied to entire columns.

    Where possible, replace full-column references with specific ranges (for example, A1:A5000).

    1. If the workbook cannot be opened

    Open a blank workbook first.

    Go to Formulas > Calculation Options > Manual > Close Excel.

    Then open the affected workbook and see if the error still appears.

    Please try and let me know, I look forward to your update.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.