Data Filter function on, but greyed out

looking to learn

Guest

Posts: n/a

3rd Feb 2009

I have a multi-tab workbook. I move lines of data from one tab to the other.
I filter the data as necessary so the data filter is on. At some point, the
filter boxes disappeared. If I go to "data.filter" on the menu, it shows teh
option as on, but greyed out as if I can not select it. I can not filter my
data at this point. Would appreciate any ideas as to what is causing the
filter function to be unusable. This is in Excel 2003.

« I can't add a calculated item to a pivot table | VLOOKUP #value error »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What function to use for filter of data?	TashaBrighton	Microsoft Excel Worksheet Functions	2	19th May 2009 01:52 PM
What function to use for filter of data?	TashaBrighton	Microsoft Excel Worksheet Functions	0	19th May 2009 12:49 PM
Data Filter Function in VBA	wayliff	Microsoft Excel Programming	1	12th Jan 2006 04:21 PM
Filter data per function	vrijbergen	Microsoft Excel Discussion	3	3rd Oct 2005 10:51 PM
Using Data filter function	=?Utf-8?B?bmV2YW5z?=	Microsoft Excel Misc	2	11th Feb 2004 06:54 PM