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-22T12:06:34+00:00

I solved my problem in this way ...instead of using a stockhistory call in lots of individual cells, I replaced this by using only one stockhistory call using 2 arrays ..one for the tickers I'm interested in and one for the dates for which I need the stock value
Was this answer helpful?

0 comments No comments
Anonymous

2025-03-22T13:36:20+00:00

I just reverted to Excel 16.92 (for Mac) and don't have the issue anymore. But I also deactivated the automatic update for office thus not getting the updates nor patches. Before doing that I waited for each update hoping it would fix the issue but none of them did : 16.93.1, 16.93.2, 16.94, 16.94.1, 16.94.2, 16.95, 16.95.1. It would at least be helpful to get an ETA so that I can reactivate the updates...
Was this answer helpful?

0 comments No comments
Jim G 134.1K Reputation points MVP

2025-03-22T14:57:03+00:00

Microsoft does not provide predictions about when bugs will be fixed.

If you want to get the test builds, you might consider joining the beta program:
Welcome to the Office Insider for Mac community!
Was this answer helpful?

0 comments No 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

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