Excel drop down question

[DeaconMet]

Does anyone know if for some reason a drop down option in excel can be lost when the file is saved?

[Rake]

Are you're referring to the drop-down list data validation?

By "lost" are you referring to the validation criteria? or the value entered into the cell?

[DeaconMet]

The validation criteria is getting lost.

[SpaceActuary]

If you're storing it as .txt or .csv, then validation criteria won't be saved. I'm assuming that's not the problem, though.

I've had it happen before that I have run a macro like this...

Dim shp as Shape
For shp in Activesheet.Shapes
    shp.Delete
Next shp

...and it will actually delete the drop-down box itself (what you would click on), while preserving the validation criteria. As I recall, the only solution that I found was to revert back to an earlier version.

It doesn't really sound like that is the issue here, though. I'm quite puzzled as to why validation criteria would be lost.

Questions:
1. What version of Excel are you using?
2. What file format (.xls, .xla, .xlsx, .xlsb, etc) are you using?
3. Are there any macros present?
4. Is validation disappearing on one or a few cells? One sheet? Or everywhere?