At the company I work at we have a Excel spreadsheet to keep track of the purchases the company made in the last year. This sheet has aproximately 1500 rows and 30 columns.
A few days ago filtering in this sheet has started to become very slow. It takes around 5 seconds to filter any column for any keyword. Which is pretty long because this sheet gets filtered a lot and it gets annoying. The sheet doesn't have any formulas or references to other sheets or files. There are two macros running on cell changes, but disabling both macros doesn't make it any faster.
I also tried to delete every row except one, but applying the filter to the remaining row still takes 5 seconds to complete.
Does anyone have a idea of why this could be so slow?