24 Dezember 2010

Anyone ever try to sort a protected Excel worksheet?

More specifically, I want to be able to retain the sorting feature available via AutoFilter. As it turns out, this is not easy to do and is something that has eluded me for the last day or so. Allow me to explain my problem. I have a spreadsheet that contains a lot of easily sortable data that is accessable by a lot of people. I don't want anyone to be able to change the values, but they still need to be able to sort. However, sorting counts as changing values within cells, so that just isn't available. I'm not going to get into the details of my trials and, in fact, I don't even care if it works anymore. I'm just going to vent.

Here's my sample worksheet.

Say I go to protect this worksheet but still want to enable some features for the users that aren't forbidden.

Okay, so duh, right? I should be able to sort and use the AutoFilter.


1 Kommentar:

Anonym hat gesagt…

Hey, I am checking this blog using the phone and this appears to be kind of odd. Thought you'd wish to know. This is a great write-up nevertheless, did not mess that up.

- David