Auto-Filter Locking - Not able to use

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

Guest

Have a large spreadsheet. Occasionally the auto-filter will lock and won't work. Have to remove all filters and turn back on - sometimes having to do this several times before the auto-filter will turn on again. Very frustrating!
 
Hi Vicki,
No expert, but right off the bat it sounds like a
memory problem. If the sheet is very large and you've got
a bunch of other stuff running, maybe it just doesn't have
room to work until something yields its memory allocation.

Just a stab, but hope it leads to the fix.
Go Navy!
-----Original Message-----
Have a large spreadsheet. Occasionally the auto-filter
Click to expand...
will lock and won't work. Have to remove all filters and
turn back on - sometimes having to do this several times
before the auto-filter will turn on again. Very
frustrating!
 
Back
Top