Excel 2007 : Performance problems (sandclock) when I filter or "unfilter" tables in a file

Hi Studiosa,

I had a similar problem recently albeit with a much larger workbook (quater of a million rows and about 100 columns in the data page alone). It was taking about 20 minutes to apply or remove just one filter! And that was with "auto calculate" turned off so the formulas on other tabs weren't calculating during that time.

Turns out one of the columns had conditional formatting to highlight certain dates if they fell before dates in another column and that's what was causing the problem.

Not saying it's definitely the same thing on your workbook, but worth a punt as the rest of your workbook sounds WELL within the limits of Excel. Have a check for conditional formatting, if there is any, remove it and see if that helps.

S.