Faster AutoFilter?

[John]

Second question today.....

Is there a way of using the Application.ScreenUpdating = False method on
AutoFilter?

I've currently got a ten column data range of about 6000 rows and the
AutoFilters takes a long time to work.

All alternative solutions welcome!

Thanks

John

 

[Frank Kabel]

Hi
try disabling automatic calculation before applying the filter

 

[Dave Peterson]

If it's mostly text, maybe you can apply the filter and then hit a key to
interrupt calculation (I hit the Escape key by habit).

The filtered data shows up nicely, but I get a "calculate" in the statusbar.
(When I'm gazing at the results, excel can calculate what it thinks it needs to
calculate.)

I do the same thing when I do Data|filter|showall.

I interrupt the calculation. I've found that excel calculates lots faster when
there's nothing filtered.