Hi forum,
I have a workbook with data validation on 8 columns that works fine, except for a couple of users (I think they are running Excel 2010). When they open the worksheet and file/save,all the data validation is removed. Before they open, for the columns in question, going to tab Data, Settings, the settings are Allow/List with Source of a section of cells containing valid values. After the 2010 user opens/saves, the Settings are changed to Allow/Any source and the reference to Source is gone. I tried protecting the cells but like so many others commented, it's too limiting. I just want to stop any person/process from resetting the data validation.
Any suggestions?
I have a workbook with data validation on 8 columns that works fine, except for a couple of users (I think they are running Excel 2010). When they open the worksheet and file/save,all the data validation is removed. Before they open, for the columns in question, going to tab Data, Settings, the settings are Allow/List with Source of a section of cells containing valid values. After the 2010 user opens/saves, the Settings are changed to Allow/Any source and the reference to Source is gone. I tried protecting the cells but like so many others commented, it's too limiting. I just want to stop any person/process from resetting the data validation.
Any suggestions?
