View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ben Ben is offline
external usenet poster
 
Posts: 1
Default Autofilter Dropdown Nonfunctional

Hello,

I am using Excel XP. I have a sheet containing approximately 800 active
rows with perhaps 25 rows actively calculating something. The sheet is
unprotected. Sheets are not grouped.

The problem is this: on occassion, the autofilter dropdown arrow does
not respond; that is, I click it, and it doesn't give me the list as it
normally would. Even after turning autofilter on and then off again
does not work. By some stroke of magic it suddenly works again later,
after I've given up on it and worked on something else.

What might be causing this and how can I avoid it?

Thank you.