View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Autofilter unavailable

You say the file is not protected but could be the worksheet is protected.

Is ToolsProtectionUnprotect Sheet available?

If not sheet protection...................

Anything else grayed out?

If you have more than one sheet selected lots of functions will be grayed
out...........AF among them.


Gord Dibben MS Excel MVP

On Wed, 2 Dec 2009 14:53:01 -0800, Julieeeee
wrote:

The Autofilter option is not available in the sheet I am working in. It is
grayed out. The file is not protected. Any ideas? (I'm using 2003)