Forum Discussion
Data Validation Drop Down List not Saving
I create a Data Validation Drop Down list in Excel, and it works while I have the workbook open, but if I save and close the Excel 97-2003 Worksheet file, then re-open the file, it does not work. Whe...
Any luck on how to fix this issue?
Not sure if you solved the problem but I faced the same today. It seems a old problem. My formula for validation contains OFFSET as other examples that I found when looking for a solution. Some people are saying to create named ranges with the OFFSET formula and use it for data validation but I didn't try that. Since to revalidate just need to open Data Validation and hit Ok, my solution was to create a macro (you can use the Recorder for that) that will create the validation for the range that I need. This code should be in Workbook_Open. Anyway, it is working now.
Gilberto_DeC I encountered this problem with an Excel 97-2003 file and solved it by re-saving my file as a "Microsoft Excel Macro-Enabled Worksheet." Then I opened the new file, re-did my validation drop-down lists (which reference data in a different worksheet), saved and closed the file. When I re-opened it to check the behavior, my data validation lists functioned correctly. Try this and see if it works for you.
/dave
