Advanced filter poor performance in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an advanced filter executed in VBA that worked great until upgrading
to Excel 2003. When I put in criteria the first time, the filtering works
fine, but when the criteria row is blanked out so that all rows are unhidden,
it takes forever for that to happen. I suspect that every formula on the
sheet is being recalculated.

Is there a technical explanation for why this problem happens now? Is there
a way to work around this without setting the sheet calculation option to
manual?
 
I've seen slow downs when filtering, but usually showing all the rows is
quicker--well at least in my experience.

And (untested), maybe you could just show all the rows with something like:

Option Explicit
Sub testme()
Dim wks As Worksheet
Set wks = ActiveSheet
With wks
If .FilterMode Then
.ShowAllData
End If
End With
End Sub



Maybe
 
Back
Top