Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Data, but allow sorting
Hello,
In Excel 2003 is it possible to protect the data in a sheet, but to allow the data to be sorted? In the Protect Sheet command, it indicates that this facility exists, but when I try to do a sort it won't do it until the sheet is unprotected. Pete |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Data, but allow sorting
Make sure that there's an empty column between the range to be sorted and any
"adjacent" data. If you have a locked cell butting up to the range to be sorted, excel yells! Pete Walburn wrote: Hello, In Excel 2003 is it possible to protect the data in a sheet, but to allow the data to be sorted? In the Protect Sheet command, it indicates that this facility exists, but when I try to do a sort it won't do it until the sheet is unprotected. Pete -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Data, but allow sorting
Dave,
I'm afraid that even with no data in any adjacent cells, I get the same problem. I need to have the cells protected, so that the data cannot be changed, but allow the column to be sorted. Pete "Dave Peterson" wrote: Make sure that there's an empty column between the range to be sorted and any "adjacent" data. If you have a locked cell butting up to the range to be sorted, excel yells! Pete Walburn wrote: Hello, In Excel 2003 is it possible to protect the data in a sheet, but to allow the data to be sorted? In the Protect Sheet command, it indicates that this facility exists, but when I try to do a sort it won't do it until the sheet is unprotected. Pete -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Data, but allow sorting
Oh, the cells need to be unlocked in that range to sort.
I think I'd do what was suggested in your other thread if you have to have the cells locked. Pete Walburn wrote: Dave, I'm afraid that even with no data in any adjacent cells, I get the same problem. I need to have the cells protected, so that the data cannot be changed, but allow the column to be sorted. Pete "Dave Peterson" wrote: Make sure that there's an empty column between the range to be sorted and any "adjacent" data. If you have a locked cell butting up to the range to be sorted, excel yells! Pete Walburn wrote: Hello, In Excel 2003 is it possible to protect the data in a sheet, but to allow the data to be sorted? In the Protect Sheet command, it indicates that this facility exists, but when I try to do a sort it won't do it until the sheet is unprotected. Pete -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Data, but allow sorting
Hi,
I have had similar instances, and have got round it by writing a macro to do the sort, and making themacro available on a menu/button or control key sequence. HRman "Pete Walburn" wrote: Hello, In Excel 2003 is it possible to protect the data in a sheet, but to allow the data to be sorted? In the Protect Sheet command, it indicates that this facility exists, but when I try to do a sort it won't do it until the sheet is unprotected. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Automatically sorting data | Excel Discussion (Misc queries) | |||
Sorting Data that feeds into other formulas.... | Excel Discussion (Misc queries) | |||
Sorting Data from 2 sheets, one sheet which is already sorted | Excel Worksheet Functions | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) |