Fix Data Validation Greyed Out

Have you ever run across the Data Validation box Greyed out in Excel?

The reason Data Validation is Greyed Out is due to the characteristics of your spreadsheet.

If you spreadsheet is “Protected” or being “Shared” with another file, the Data validation tool is turned off in Excel. This is to protect the linked data from producing an error.

Annoying right! In order to fix this issue, make sure you unprotect your worksheet. The other option is to copy the data set into a new worksheet that is not shared. This will allow you to reactivate the data validation tool.

Data Validation Greyed Out

Leave a Reply

Randomly Sort Data in Excel

Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

Read More »
Scroll to Top