| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Online worksheet and remain sortable?
I want to post an Excel worksheet online, and I want it to remain sortable
but keep the content unalterable. The content is in A12 thru I34. Column A has a heading of "Rank" and shows ranking of values in Column D, so Column D is the basis for the sort. Let me know if more info is needed. Thanks for any help that can be provided! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Online worksheet and remain sortable?
By definition you can't have it both ways: Sorting implies alteration. A
solution would be to protect the worksheet and have a button to access a macro that removes the protection, does the sort and places the sheet back into the protected state. Once again we must face the fact that passwords on workbooks and worksheets are 'weak' and intended to prevent accidental alteration of the data rather than provide security. "guyfromage" wrote: I want to post an Excel worksheet online, and I want it to remain sortable but keep the content unalterable. The content is in A12 thru I34. Column A has a heading of "Rank" and shows ranking of values in Column D, so Column D is the basis for the sort. Let me know if more info is needed. Thanks for any help that can be provided! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Online worksheet and remain sortable?
Thanks for the response!
Can that process be done w/in IE? "JLatham" wrote: By definition you can't have it both ways: Sorting implies alteration. A solution would be to protect the worksheet and have a button to access a macro that removes the protection, does the sort and places the sheet back into the protected state. Once again we must face the fact that passwords on workbooks and worksheets are 'weak' and intended to prevent accidental alteration of the data rather than provide security. "guyfromage" wrote: I want to post an Excel worksheet online, and I want it to remain sortable but keep the content unalterable. The content is in A12 thru I34. Column A has a heading of "Rank" and shows ranking of values in Column D, so Column D is the basis for the sort. Let me know if more info is needed. Thanks for any help that can be provided! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I post an Excel worksheet online so that it remains sortabl | Excel Discussion (Misc queries) | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| History worksheet - can it remain viewable after saving? | Excel Worksheet Functions | |||
| Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
| How do I reduce the worksheet size ? | Excel Discussion (Misc queries) | |||
Linear Mode
