I have Microsoft 2010 and manage an Excel Shared Workbook. Every time I open it the Data Validation I set up is no longer there. I unshare the workbook, reinstate the validation rules (drop down lists in two columns), re-share the workbook and save. The drop downs are then lost when I open it again.

I appreciate any advice you can offer!