tiredExcelUser
New Member
- Joined
- Feb 9, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have a model with a lot of dropdown lists that refer to a validation list in the same sheet. sometimes a user will accidentally delete the list that the dropdown is referring to. this results in a #REF! error in the data validation source for the dropdown but that doesn't show up in the error check. does anyone know how to search the file to see if any of the dropdowns have an error in their sources?