Auto Filter

depks

Board Regular
Joined
Sep 14, 2004
Messages
82
Good day,
I received an Excel Workbook from my friend in which AutoFilter option is disabled. Workbook/Worksheet is not Protected in any manner. Any solution?
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Sorry to be picky, but how do you know that the Worksheet is not Protected ( how did you check )?
 

depks

Board Regular
Joined
Sep 14, 2004
Messages
82
Well, Checked Tool->Protection..checked for both Protect sheet and workbook options.

Sorry to be picky, but how do you know that the Worksheet is not Protected ( how did you check )?
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Check for macros? Do other workbooks work ok after you've opened this one? Is the focus on a graphic object?
 

depks

Board Regular
Joined
Sep 14, 2004
Messages
82

ADVERTISEMENT

Yes..
-Did check for Macros. No macros.
-Other workbooks work normally after opening this workbook.
-No objects included
Please note:When I copy the contents to a different workbook, it works fine. But, does not work when I copy to different sheets in the same workbook.

Check for macros? Do other workbooks work ok after you've opened this one? Is the focus on a graphic object?
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Hmmmm, strange. What version of Excel are you using, out of curiosity?
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
I can't help for a few days then ... only have access to Excel 97 and Excel 2000 until the weekend.
 

Forum statistics

Threads
1,141,757
Messages
5,708,349
Members
421,566
Latest member
7Nabisco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top