Autofilter doesn't activate?

  • Thread starter Thread starter Andreas
  • Start date Start date
A

Andreas

Hi all. I have a *very* strange problem. One of our users
work a lot in Excel (Uses Excel 2000) and she's having a
problem with autofilter. After a while when working, when
she's trying to apply an autofilter, nothing happens. No
listboxes, nothing. When going back to see if it's
checked, it is. But alas.. nothing. Co-workers performing
the same task on the same files, get it to work every
time. I've tried re-installing it but the problem
remains. She's working on a P4, 2,4 Ghz, 256MB RAM, so it
shouldn't be a memoryproblem. CPU-usage doesn't rise
above 50%...

Any thoughts or ideas would be very welcome!

/Andreas
 
Hi,

All I can come up with is this:

Autofilter uses a hidden Defined name called

Sheet1!_Filterdatabase

If one deletes that name whilst the autofilter is enabled,
weird things like the one you described may occur.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Back
Top