Excel Error "Excel ran out of resources while attempting to calculate" upon calculation interruption

Anonymous

I am using Excel, latest version for Mac, 16.93.1 (25011917), and following a recent update either to 16.93 or 16.93.1 I have systematically an error message if I interrupt a calculation : "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated." after this error I must always quit excel and restart which is very annoying. Anyone having the same issue ?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

63 answers

Anonymous

2025-03-24T07:25:36+00:00

Excellent, thanks. Fingers crossed for a swift resolution.

The problem sometimes occurs with lower NumDays values but that may be related to other spreadsheets that I have open.
Was this answer helpful?

0 comments No comments
Anonymous

2025-03-24T04:08:57+00:00

Thanks! I could use this example to reliably reproduce the problem (I found that NumDays=20000 would trigger). I sent this and related logs/screencapture to Microsoft Support.
Was this answer helpful?

0 comments No comments
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Anonymous

I have a table (StockList) containing a single column of tickers and I have a cell (labelled NumDays) that specifies the number of days of stock history to return.

The table of stock prices is generated by the function shown below. However, it intermittently fails, particularly when NumDays is large.

=LET(

    endDate, TODAY(),

    startDate, endDate - NumDays,

    allDates, SEQUENCE(endDate - startDate, 1, startDate),

    numStocks, ROWS(StockList),

    stockSymbols, CHOOSECOLS(StockList, 1),

    prices, REDUCE(

        allDates,

        SEQUENCE(numStocks, 1, 1),

        LAMBDA(acc,i,

            LET(

                history, STOCKHISTORY(INDEX(stockSymbols, i, 1), startDate, endDate, 0, 1),

                HSTACK(

                    acc,

                    IFERROR(XLOOKUP(allDates, CHOOSECOLS(history, 1), CHOOSECOLS(history, 2),NA(), -1), NA())

                )

            )

        )

    ),

    header, HSTACK("Date", TRANSPOSE(stockSymbols)),

    VSTACK(header, prices)

)

0 comments

Anonymous

2025-03-23T11:21:24+00:00

Thanks for the feedback Jim. I just tried the beta version 16.96 and it still doesn't fix the issue. What's more is that I don't know if a certain beta will fix the issue as it is not mentioned, so the only way is to test it : but I can't have simultaneously 2 versions of Excel, for example 16.92 which doesn't have the issue and 16.96 which still has, so each time, after updating to a new beta and testing it, I have to remove it and then re-install the 16.92...
Was this answer helpful?

0 comments No comments