Auto-Filter Locking - Not able to use

  • Thread starter Vickie Schroeder
  • Start date
V

Vickie Schroeder

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!
 
H

hcj

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Filter - It's broken! Help! (Office '03) 2
Protected Sheets 2
auto filter on columns 2
Auto Filter Multiple Criteria 1
Auto Filter Comma Dilemiation 2
subtotal function won't work 1
Global Template Network and saving auto texts & macros 2
Dynamic Filtering...Need Help 0

Top