Auto filter is greyed out

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

Hi, for some reason one of my work books is suddenly refusing to let me
use autofilter on all of my worksheets within the book - the option is
greyed out. It is also refusing to allow me to use the trace
precedents and trace dependents functions, it is almost as if the
option has been "turned off" by accident, but I dont know how to turn
it back on.

I would really appreciate any suggestions, I have tried looking at the
trouble shooting guide in microsoft but it doesnt really help....
HELP!!!!!

Many thanks in advance

Laura
 
By the way, my work book is not protected (it seems) and also I dont
have more than one sheet selected (it seems)
 
Laura said:
By the way, my work book is not protected (it seems) and also I dont
have more than one sheet selected (it seems)
Click to expand...

Hello, to anyone that is intersted, I worked out the answer

I managed to reinstate my auto filter by going to tools/options/view
and selected to view all objects. Who knows why it was turned off, but
nevermind, it works now!
 
Back
Top