Excel does allow sorting on a protected worksheet SPORATICALLY. 30 excels allow 5 do not.

%3CLINGO-SUB%20id%3D%22lingo-sub-2319967%22%20slang%3D%22en-US%22%3EExcel%20does%20allow%20sorting%20on%20a%20protected%20worksheet%20SPORATICALLY.%2030%20excels%20allow%205%20do%20not.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2319967%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20surgery%20checklists%20I%20created%20for%20our%20company.%20The%20user%20can%20add%20a%20date%2C%20MR%23%2C%20Patient%20name%20then%20the%20columns%20have%20lists%20enabled%20for%20them%20to%20choose%20certain%20status%20based%20on%20the%20column%20header%20(The%20patient's%20surgery%20packet%20was%20mailed%2C%20orders%20sent%20to%20OR%2C%20case%20confirmed%2C%20pre-op%20received%20etc.%20I%20made%20the%20sheet%20protected%20because%20the%20schedulers%20will%20easily%20move%20the%20lists%20around%20to%20each%20column%2C%20unfortunately%20excel%20doesn't%20allow%20for%20that%20to%20be%20just%20locked.%20I%20need%20the%20surgery%20date%2C%20patient%20name%20and%20the%20MR%23%20to%20be%20able%20to%20be%20a%20fillable%20field%20and%20the%20surgery%20scheduler%20to%20sort%20by%20surgery%20date.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20lock%20the%20excel%20and%20allow%20sorting%20enabled%2C%2025%20excel%20sheets%20allow%20the%20scheduler%20to%20sort%20and%20the%20other%205%20excel%20sheets%20cannot%20sort%20no%20matter%20what%20I%20try!%3C%2FP%3E%3CP%3EThe%20filters%20and%20layouts%20are%20exactly%20the%20same%2C%20so%20what%20makes%20these%205%20excels%20so%20special%20that%20every%20time%20they%20try%20to%20sort%20by%20date%20the%20error%20of%20%22The%20cell%20or%20chart%20you%20are%20trying%20to%20change%20is%20on%20a%20protected%20sheet.%20To%20make%20a%20change%20unprotect%20sheet%2C%20you%20may%20need%20to%20put%20in%20a%20password%22.%26nbsp%3B%3C%2FP%3E%3CP%3EWhy!%3C%2FP%3E%3CP%3EI%20have%20been%20on%20every%20website%20that%20says%20to%20try%20this%20and%20try%20that%20and%20NOTHING.%20It%20still%20gives%20the%20same%20message%20on%20only%205%20of%20these%20excels%20and%20all%20the%20others%20are%20able%20to%20sort%20just%20fine.%20We%20need%20to%20protect%20the%20sheets%20to%20make%20sure%20the%20lists%20don't%20change%20columns%20since%20the%20schedulers%20who%20aren't%20that%20tech%20savvy%20can%20move%20the%20lists%20to%20the%20next%20column%20or%20even%20all%20over%20the%20place.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat's%20the%20glitch%20and%20it%20needs%20to%20get%20fixed.%20I%20see%20a%20lot%20of%20posts%20through%202007%20-%202020%20saying%20the%20same%20thing%20but%20no%20one%20is%20trying%20to%20fix%20this%20crucial%20issue.%20All%20Microsoft%20responses%20are%20send%20us%20an%20example%20we%20can't%20fix%20it%20without%20it.%20I%20see%20so%20many%20posts%20about%20it%20why%20aren't%20the%20developers%20figuring%20this%20out%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20problem%20child%20to%20this%20message%20to%20figure%20out%20why%20this%20is%20happening%20to%20a%20very%20few%20excels%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2319967%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have surgery checklists I created for our company. The user can add a date, MR#, Patient name then the columns have lists enabled for them to choose certain status based on the column header (The patient's surgery packet was mailed, orders sent to OR, case confirmed, pre-op received etc. I made the sheet protected because the schedulers will easily move the lists around to each column, unfortunately excel doesn't allow for that to be just locked. I need the surgery date, patient name and the MR# to be able to be a fillable field and the surgery scheduler to sort by surgery date. 

 

When I lock the excel and allow sorting enabled, 25 excel sheets allow the scheduler to sort and the other 5 excel sheets cannot sort no matter what I try!

The filters and layouts are exactly the same, so what makes these 5 excels so special that every time they try to sort by date the error of "The cell or chart you are trying to change is on a protected sheet. To make a change unprotect sheet, you may need to put in a password". 

Why!

I have been on every website that says to try this and try that and NOTHING. It still gives the same message on only 5 of these excels and all the others are able to sort just fine. We need to protect the sheets to make sure the lists don't change columns since the schedulers who aren't that tech savvy can move the lists to the next column or even all over the place. 

 

What's the glitch and it needs to get fixed. I see a lot of posts through 2007 - 2020 saying the same thing but no one is trying to fix this crucial issue. All Microsoft responses are send us an example we can't fix it without it. I see so many posts about it why aren't the developers figuring this out?

 

I have attached the problem child to this message to figure out why this is happening to a very few excels?

 

0 Replies