Forum Discussion
Data Validation Drop Down List not Saving
I am having the very same issue with Office 365. Something with an update? This was working before but not today. I map the list and can use it to enter data but then after saving the file and reopening the map for the list is gone.
- Any luck on how to fix this issue?
In my original Excel file, my drop-down lists were in a separate worksheet. What worked for me: I moved the drop-down lists to the same worksheet and remapped the location. This is not as clean and a little more cumbersome when I need to modify the lists, but it's a go-around that is working for now.
- 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
