Data Validation

%3CLINGO-SUB%20id%3D%22lingo-sub-283913%22%20slang%3D%22en-US%22%3EData%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-283913%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20that%20the%20team%20are%20sharing%20and%20have%20inserted%20data%20validation%20drop%20downs.%3C%2FP%3E%3CP%3EThese%20have%20stopped%20working%2C%20cannot%20select%20from%20list%2C%20cannot%20remove%20dalat%20validation%20either.%3C%2FP%3E%3CP%3EWhen%20I%20select%20the%20column%20and%20click%20Data%20Validation%20the%20only%20options%20left%20%2Cnot%20greyed%20out%20are%20circle%20data%20validation%20and%20clear%20circled%20data%20validation.The%20DataValidation%20option%20is%20greyed%20out%20so%20I%20cant%20remove%20the%20data%20validation%20in%20settings.%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-283913%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%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285060%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285060%22%20slang%3D%22en-US%22%3EHas%20the%20the%20worksheet%20been%20protected%20by%20mistake%3F%3C%2FLINGO-BODY%3E
Deleted
Not applicable

I have a spreadsheet that the team are sharing and have inserted data validation drop downs.

These have stopped working, cannot select from list, cannot remove dalat validation either.

When I select the column and click Data Validation the only options left ,not greyed out are circle data validation and clear circled data validation.The DataValidation option is greyed out so I cant remove the data validation in settings.

Any ideas?

3 Replies
Has the the worksheet been protected by mistake?

@Wyn Hopkins 

 

Hello.  I have tried all options that have been listed since 2017 but I still cannot remove drop down lists from an Excel spreadsheet.  The sheet is not protected. 

 

Please help.  

Can you attach a copy of the problem file ( removing all the data if sensitive )