Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 10th 08, 11:20 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 12
Default Auto filter sort ascending not working while sheet protected

I have a sheet with a couple of columns that contain formulas, so I have
protected those columns and left the rest of the sheet open for data entry.
The problem is, now when I try to sort ascending or descending (on a column
containing dates) using the auto filter, it just does not work at all.

Any suggestions?
--
TommyB

  #2   Report Post  
Old July 11th 08, 12:27 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default Auto filter sort ascending not working while sheet protected

If you have Excel 2000 (and maybe 2002 - I'm not sure exactly when it
was changed) then you will not be able to sort on a sheet which is
protected. Later versions did allow certain options when the sheet was
protected, but I'm not sure if those extended to sorting.

Pete

On Jul 10, 11:20*pm, TommyB wrote:
I have a sheet with a couple of columns that contain formulas, so I have
protected those columns and left the rest of the sheet open for data entry.
The problem is, now when I try to sort ascending or descending (on a column
containing dates) using the auto filter, it just does not work at all.

Any suggestions?
--
TommyB


  #3   Report Post  
Old July 11th 08, 12:43 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 12
Default Auto filter sort ascending not working while sheet protected

I am using Excel 2003. After locking the cells with the formulas in them I go
to Protect Sheet and it gives me a bunch of check boxes for the things I want
to allow users of the worksheet to do. One of them is sort. I check that box
and then apply protection. However, when I go back to AutoFilter from the
column header and click "sort ascending" it will not allow me to. It says "
the worksheet is protected and cannot perform the change you are requesting".

Anything else I could be missing here?

Thanks for all of your help.
--
TommyB


"Pete_UK" wrote:

If you have Excel 2000 (and maybe 2002 - I'm not sure exactly when it
was changed) then you will not be able to sort on a sheet which is
protected. Later versions did allow certain options when the sheet was
protected, but I'm not sure if those extended to sorting.

Pete

On Jul 10, 11:20 pm, TommyB wrote:
I have a sheet with a couple of columns that contain formulas, so I have
protected those columns and left the rest of the sheet open for data entry.
The problem is, now when I try to sort ascending or descending (on a column
containing dates) using the auto filter, it just does not work at all.

Any suggestions?
--
TommyB



  #4   Report Post  
Old July 11th 08, 12:52 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Auto filter sort ascending not working while sheet protected

You can allow autofiltering on protected sheets from 2002 onward.

Autofilter must be in place before protecting the worksheet with "use
autofilter" checkmarked.

i.e. Arrows must be showing

As far as sorting........there is a checkbox to allow sorting, but I have never
been able to get Excel to sort on a protected sheet without unlocking all cells,
which kinda defeats the purpose of protecting a sheet<g

Might be a good chance I don't know what I'm doing??


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 16:27:19 -0700 (PDT), Pete_UK wrote:

If you have Excel 2000 (and maybe 2002 - I'm not sure exactly when it
was changed) then you will not be able to sort on a sheet which is
protected. Later versions did allow certain options when the sheet was
protected, but I'm not sure if those extended to sorting.

Pete

On Jul 10, 11:20*pm, TommyB wrote:
I have a sheet with a couple of columns that contain formulas, so I have
protected those columns and left the rest of the sheet open for data entry.
The problem is, now when I try to sort ascending or descending (on a column
containing dates) using the auto filter, it just does not work at all.

Any suggestions?
--
TommyB


  #5   Report Post  
Old July 11th 08, 01:57 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 12
Default Auto filter sort ascending not working while sheet protected

Thanks Gord. Interesting that when I choose to allow sort from their provided
list, it does not work... Oh well...

BTW, this group is great. I have learned more in the last month than ever
taking classes.
--
TommyB


"Gord Dibben" wrote:

You can allow autofiltering on protected sheets from 2002 onward.

Autofilter must be in place before protecting the worksheet with "use
autofilter" checkmarked.

i.e. Arrows must be showing

As far as sorting........there is a checkbox to allow sorting, but I have never
been able to get Excel to sort on a protected sheet without unlocking all cells,
which kinda defeats the purpose of protecting a sheet<g

Might be a good chance I don't know what I'm doing??


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 16:27:19 -0700 (PDT), Pete_UK wrote:

If you have Excel 2000 (and maybe 2002 - I'm not sure exactly when it
was changed) then you will not be able to sort on a sheet which is
protected. Later versions did allow certain options when the sheet was
protected, but I'm not sure if those extended to sorting.

Pete

On Jul 10, 11:20 pm, TommyB wrote:
I have a sheet with a couple of columns that contain formulas, so I have
protected those columns and left the rest of the sheet open for data entry.
The problem is, now when I try to sort ascending or descending (on a column
containing dates) using the auto filter, it just does not work at all.

Any suggestions?
--
TommyB





  #6   Report Post  
Old March 17th 10, 10:27 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 16
Default Auto filter sort ascending not working while sheet protected

Yea it remains strange that you have a checkbox "allow users to use
filter/auto filter" excel than blocks this option.

So Microsoft: PLEASE FIX THIS BUG!!.

On this website numerous posts on this issue, many people experience this
problem. Using macro is complex and unnecessary when the checkbox would work
as required. Macro's are also not ideal because im making sheets who needs to
be bullet proof, for less experienced users.

PS: Im using excel 2007 on XP with all updates.

Thanks other users of this forum for your post, all helpful.

brgds Olivier



"TommyB" wrote:

Thanks Gord. Interesting that when I choose to allow sort from their provided
list, it does not work... Oh well...

BTW, this group is great. I have learned more in the last month than ever
taking classes.
--
TommyB


"Gord Dibben" wrote:

You can allow autofiltering on protected sheets from 2002 onward.

Autofilter must be in place before protecting the worksheet with "use
autofilter" checkmarked.

i.e. Arrows must be showing

As far as sorting........there is a checkbox to allow sorting, but I have never
been able to get Excel to sort on a protected sheet without unlocking all cells,
which kinda defeats the purpose of protecting a sheet<g

Might be a good chance I don't know what I'm doing??


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 16:27:19 -0700 (PDT), Pete_UK wrote:

If you have Excel 2000 (and maybe 2002 - I'm not sure exactly when it
was changed) then you will not be able to sort on a sheet which is
protected. Later versions did allow certain options when the sheet was
protected, but I'm not sure if those extended to sorting.

Pete

On Jul 10, 11:20 pm, TommyB wrote:
I have a sheet with a couple of columns that contain formulas, so I have
protected those columns and left the rest of the sheet open for data entry.
The problem is, now when I try to sort ascending or descending (on a column
containing dates) using the auto filter, it just does not work at all.

Any suggestions?
--
TommyB



  #7   Report Post  
Old March 17th 10, 02:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 140
Default Auto filter sort ascending not working while sheet protected

I had issues with this too. In situations where I want to just share data,
I do the following.

1. I do not use the worksheet protection.
2. I password protect the workbook.
3. To share the data with others, I create a .CSV version(sorted or
whatever).

"Olivier" wrote in message
...
Yea it remains strange that you have a checkbox "allow users to use
filter/auto filter" excel than blocks this option.

So Microsoft: PLEASE FIX THIS BUG!!.

On this website numerous posts on this issue, many people experience this
problem. Using macro is complex and unnecessary when the checkbox would
work
as required. Macro's are also not ideal because im making sheets who needs
to
be bullet proof, for less experienced users.

PS: Im using excel 2007 on XP with all updates.

Thanks other users of this forum for your post, all helpful.

brgds Olivier



"TommyB" wrote:

Thanks Gord. Interesting that when I choose to allow sort from their
provided
list, it does not work... Oh well...

BTW, this group is great. I have learned more in the last month than ever
taking classes.
--
TommyB


"Gord Dibben" wrote:

You can allow autofiltering on protected sheets from 2002 onward.

Autofilter must be in place before protecting the worksheet with "use
autofilter" checkmarked.

i.e. Arrows must be showing

As far as sorting........there is a checkbox to allow sorting, but I
have never
been able to get Excel to sort on a protected sheet without unlocking
all cells,
which kinda defeats the purpose of protecting a sheet<g

Might be a good chance I don't know what I'm doing??


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 16:27:19 -0700 (PDT), Pete_UK
wrote:

If you have Excel 2000 (and maybe 2002 - I'm not sure exactly when it
was changed) then you will not be able to sort on a sheet which is
protected. Later versions did allow certain options when the sheet was
protected, but I'm not sure if those extended to sorting.

Pete

On Jul 10, 11:20 pm, TommyB wrote:
I have a sheet with a couple of columns that contain formulas, so I
have
protected those columns and left the rest of the sheet open for data
entry.
The problem is, now when I try to sort ascending or descending (on a
column
containing dates) using the auto filter, it just does not work at
all.

Any suggestions?
--
TommyB




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
Use auto filter in a protected worksheet James Excel Discussion (Misc queries) 6 June 2nd 15 03:18 AM
Sort Ascending after filter. Kenny Excel Discussion (Misc queries) 3 October 11th 07 02:21 PM
Sort Ascending Using Auto-Filter Ignores First Row jgraves Excel Discussion (Misc queries) 1 July 26th 07 02:14 PM
Auto Filter - Protected sheet/workbook ronwill Excel Discussion (Misc queries) 3 January 10th 06 03:28 PM
Filter not working in a protected file jijy Excel Worksheet Functions 1 August 3rd 05 06:02 PM


All times are GMT +1. The time now is 03:01 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017