ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Have you had a problem with Auto Filter freezing? (https://www.excelbanter.com/excel-discussion-misc-queries/57915-have-you-had-problem-auto-filter-freezing.html)

Florida User

Have you had a problem with Auto Filter freezing?
 
I'm currently using Excel 2003. Numerous times when using the Auto Filter
feature the filters will stop working. The tabs remain at the top of the
column but do not function, actually freezing in a filtered position. By
removing the Auto Filter and reapplying it I can get all the data to all the
display and sometimes by reapplying Auto Filter the function will work. This
is not always the case. Has anyone encountered this and how did you fix it?
Thanks.

Dave Peterson

Have you had a problem with Auto Filter freezing?
 
I don't recall ever seeing this in xl2003, but I've seen it other versions.

The only solution I've found is what you're currently doing.

(Your post looked lonely without a response.)

Florida User wrote:

I'm currently using Excel 2003. Numerous times when using the Auto Filter
feature the filters will stop working. The tabs remain at the top of the
column but do not function, actually freezing in a filtered position. By
removing the Auto Filter and reapplying it I can get all the data to all the
display and sometimes by reapplying Auto Filter the function will work. This
is not always the case. Has anyone encountered this and how did you fix it?
Thanks.


--

Dave Peterson

CLR

Have you had a problem with Auto Filter freezing?
 
I run into something similar to this, the "apparent freezing", that is, (on
XL97 with a 866 cpu) with a rather large database, (say 15000 rows or
so)...........usually it clears if I let it sit long enough <G

Vaya con Dios,
Chuck, CABGx3



"Florida User" wrote:

I'm currently using Excel 2003. Numerous times when using the Auto Filter
feature the filters will stop working. The tabs remain at the top of the
column but do not function, actually freezing in a filtered position. By
removing the Auto Filter and reapplying it I can get all the data to all the
display and sometimes by reapplying Auto Filter the function will work. This
is not always the case. Has anyone encountered this and how did you fix it?
Thanks.



All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com