Autofilter Grayed Out...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have never seen AutoFilter grayed out and unusable.
Advanced Filter is available but that is not what I
want. Any clues as to why AutoFilter is unusable.
 
That was my initial thought also but it was not
protected. What I had done was save the results of a
Agent Ransack directory search as a text file. I
converted that text file to an Excel file. I also
exported a table from Access into Excel. The "Agent
Ransack" and "Access" Excel spreadsheets had the
AutoFilter capability. However, when I copied the single
columns in both of those spreadsheets and pasted them
into columns A & B of a new spreadsheet, the AutoFilter
capability was grayed out. So, I decided to heck with it
and went about completing my task in a different manner.
At this point I have chalked up the graying of the
AutoFilter to "one of those odd, unexplainable things."
Andrew
 
That was my initial thought also but it was not
protected. What I had done was save the results of a
Agent Ransack directory search as a text file. I
converted that text file to an Excel file. I also
exported a table from Access into Excel. The "Agent
Ransack" and "Access" Excel spreadsheets had the
AutoFilter capability. However, when I copied the single
columns in both of those spreadsheets and pasted them
into columns A & B of a new spreadsheet, the AutoFilter
capability was grayed out. So, I decided to heck with it
and went about completing my task in a different manner.
At this point I have chalked up the graying of the
AutoFilter to "one of those odd, unexplainable things."
Click to expand...

Hadn't selected more than one sheet had you ? I just tried
autofiltering 5 sheets ... and it was greyed out. There were other
options I hadn't seen before (don't recall if advanced filter was
greyed out or not).

Bruce

-----------------------------------------------------------------------
It was so much easier to blame it on Them. It was bleakly depressing to
think that They were Us. If it was Them, then nothing was anyone´s fault.
If it was Us, what did that make Me ? After all, I´m one of Us. I must be.
I´ve certainly never thought of myself as one of Them. No-one ever thinks
of themselves as one of Them. We´re always one of Us. It´s Them that do
the bad things. <=> Terry Pratchett. Jingo.
 
try ungrouping the sheets.
rightclick over Sheet_X tab that you are using and select ungroup.

Ed
 
Nice and easy!

Hi,

I had the grayed out issue too. Resolved as soon as the the tabs were ungrouped. I'm not sure how the sheets actually got grouped in the first place! Nonetheless, thanks for making it work :).
 
Back
Top