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.