Fix Data Validation Greyed Out

Originally published at: How to Fix Data Validation Greyed Out in Excel - Excelbuddy.com

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…