Data Validation in XLS Padlock


#1

I sent an email, but thought I would ask the question here too.

I have a spreadsheet with multiple pages, hundreds of formulas, and many, many drop-down menus that are handled by data validation in Excel.

Will those drop-downs not work in a compiled workbook?


#2

No problem, you can still use data validation and drop-downs in your compiled workbooks.
Data validation is not compatible with our formula protection. So, for cells with data validation, don’t add them to the Protection list, and it will still work as expected.