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.