Data Validation suddenly eliminated from a file.

%3CLINGO-SUB%20id%3D%22lingo-sub-3531724%22%20slang%3D%22ja-JP%22%3EData%20Validation%20suddenly%20eliminated%20from%20a%20file.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3531724%22%20slang%3D%22ja-JP%22%3E%3CP%3EWhen%20I%20opened%20some%20excel%20file%2C%20I%20found%20that%20%22Data%20Validation%22%20has%20been%20eliminated%20from%20the%20file%20even%20I%20didn't%20anything.%3C%2FP%3E%3CP%3EDidn't%20changed%20excel%20version%20or%20anything.%3C%2FP%3E%3CP%3ECan%20someone%20tell%20me%20what%20is%20potential%20reason%20for%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3531724%22%20slang%3D%22ja-JP%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3532469%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%20suddenly%20eliminated%20from%20a%20file.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3532469%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1430911%22%20target%3D%22_blank%22%3E%40ryo_takahashi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20i%20may%20ask%20naively%20%3A)...%3C%2FP%3E%3CP%3EDid%20you%20click%20the%20cell%20again%3F%3C%2FP%3E%3CP%3EThis%20drop-down%20is%20only%20displayed%20when%20the%20cell%20is%20selected.%3C%2FP%3E%3CP%3EIf%20not...then%20save%20the%20file%20in%20.xlsx%20format%20if%20still%20in%20the%20old%20.xls%20format.%3C%2FP%3E%3CP%3EWould%20additionally%20and%20perhaps%20in%20advance%20carry%20out%20an%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frepair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EExcel%20repair%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fupdate-office-with-microsoft-update-f59d3f9d-bd5d-4d3b-a08e-1dd659cf5282%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EOffice%20update%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

When I opened some excel file, I found that "Data Validation" has been eliminated from the file even I didn't anything.

Didn't changed excel version or anything.

Can someone tell me what is potential reason for this?

1 Reply

@ryo_takahashi 

if i may ask naively :)...

Did you click the cell again?

This drop-down is only displayed when the cell is selected.

If not...then save the file in .xlsx format if still in the old .xls format.

Would additionally and perhaps in advance carry out an Excel repair and Office update.