Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default My autofilter is dimmed in one worksheet only in Excel 2003 how d.

I have a Excel 2003 file with multiple sheet and I am unable to autofilter,
it is dimmed and I have been unable to activate it .
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 27
Default My autofilter is dimmed in one worksheet only in Excel 2003 how d.



On Oct 9, 12:26 pm, LarrW wrote:
I have a Excel 2003 file with multiple sheet and I am unable to autofilter,
it is dimmed and I have been unable to activate it .


Sounds like your sheet is protected. You can unprotect it by clicking
toolsprotection. if there is a password set, you'll need to have that
as well

HTH

AR

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default My autofilter is dimmed in one worksheet only in Excel 2003 ho

protection is not on

"ducky" wrote:



On Oct 9, 12:26 pm, LarrW wrote:
I have a Excel 2003 file with multiple sheet and I am unable to autofilter,
it is dimmed and I have been unable to activate it .


Sounds like your sheet is protected. You can unprotect it by clicking
toolsprotection. if there is a password set, you'll need to have that
as well

HTH

AR


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default My autofilter is dimmed in one worksheet only in Excel 2003 ho

If you have more than one sheet selected, AutoFilter won't be available,
and [Group] will appear at the end of the file name in the Title Bar.

LarrW wrote:
protection is not on

"ducky" wrote:



On Oct 9, 12:26 pm, LarrW wrote:

I have a Excel 2003 file with multiple sheet and I am unable to autofilter,
it is dimmed and I have been unable to activate it .


Sounds like your sheet is protected. You can unprotect it by clicking
toolsprotection. if there is a password set, you'll need to have that
as well

HTH

AR





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 06:04 PM
Using Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 02:36 AM
converted square brackets in worksheet name excel 2003 Djorre Excel Discussion (Misc queries) 0 August 1st 06 10:00 AM
Excel 2003 - Autofilter Question windsong Excel Discussion (Misc queries) 4 December 13th 05 08:11 PM
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet Graham Jones Excel Discussion (Misc queries) 1 May 13th 05 12:58 AM


All times are GMT +1. The time now is 08:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"