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

2 thoughts on “Fix Data Validation Greyed Out”

  1. Can you post a snippet from your spreadsheet. Maybe we can help from there? Typically it’s something very simple when it comes to excel.

Leave a Reply


The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax: =YEARFRAC(start_date, end_date,

Read More »
Scroll to Top