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!

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!

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!