Online worksheet and remain sortable?

G

guyfromage

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!
 
J

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I post an Excel worksheet online so that it remains sortabl 0
Can the IF function be used with values from multiple worksheets? 4
Sorting by numbers w/ words in the same cells 2
Using Index, Match and Search to populate items to a calendar view 2
Worksheet Formula Issues 4
CSV file conversion + True/False over multiple columns of data 1
Conditional format row based on Percentile in one cell? 2
Worksheet problem 3

Top