I am working with the Access Analytic template for multi level dependant data validation drop downs.
https://accessanalytic.com.au/easiest-excel-multiple-row-dependent-drop-down-list/
But when I attempt to recreate the data validation for the cells excel throws the error
“This entry leads to an error, Try entering different values to continue”
This is despite the template already having the data validation inputted and clearly working.
I have attempted to manually recreate the template in multiple different excel environments to no avail.
Can anyone advise what issue I am having here and how to resolve it, I am working with Microsoft 365 and have attempted to use Excel 2013 as well
Random Stalka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.