Performance is slow after entering a cell on my spreadsheet, how can I diagnose? Some info:
Entering data into any cell and then leaving it (validating it) will result in a 1-2 second delay.
It wasn’t slow before–I was playing around with formatting (including conditional formatting).
I copied all the cells and paste them into a new sheet. Removed conditional and direct formatting with all cells, same issue. However, as soon as I scroll the new spreadsheet down one notch, there are no delays to any cells–everything’s normal. Even if I do the same and scroll down one notch on the original spreadsheet, there are still delays and it doesn’t help.
What could be causing the performance issue? I don’t have complicated conditional formats and I would think removing all formatting of cells on the new copy of the test spreadsheet would remove all issues.