Apr 13 2021 11:37 AM
I've suddenly found myself unable to delete rows from my Excel spreadsheet and I have no idea why. When I attempt it I get a message saying that "the operation may take a significant amount of time" and then I press OK, but nothing happens.
Apr 13 2021 01:09 PM
Such message appears if Excel expects large amount of recalculations due to the action. That's not necessary formulas in cells, could be conditional formatting rules, whatever.
Try to switch on Manual calculation mode before removing rows (Formulas -> Calculation Options).
Apr 13 2021 03:04 PM
Apr 14 2021 02:39 AM
@Sue_Copeland , glad to know you sorted this out, thank you for the update.