Once deleted, add the array formula again in the first cell and then copy it down to the required cells. Read: Excel ran out of resources while attempting to calculate formulas.

The Problem: Dynamic Array Formulas Don't Work in Excel Tables A dynamic array formula is a formula whose result spills over from one cell to other cells.

There are other array formulas in Excel you should have in your arsenal. RANDARRAY is only available in Excel 2021 and Excel 365, and cant be found in earlier versions of Excel.

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows formulas to output values to more than one cell at a time.

Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.