excel ribbon is greyed out sheet disappeared

In the opened window type the password, and then click OK. Behind the protect workbook, the presence of colored background is an indication that the protection is active. Check to make sure you do not have any macros. To enable the Freeze Panes option again, you need to unprotect your Excel workbook: Tap to the Review tab from the Excel ribbon. Not all features are available in Excel 2010. If you accidentally select multiple spreadsheets, this will cause an error.

To inactivate, use the steps below.įrom the toolbar Ribbon Select: “Review” – “Unshare Workbook” Possible Reason 2: One Sheet SelectedĬheck to make sure you are only selecting one worksheet. If the file is actively being shared, this will be active. This will allow you to reactivate the data validation tool. The other option is to copy the data set into a new worksheet that is not shared. This is to protect the linked data from producing an error.Īnnoying right! In order to fix this issue, make sure you unprotect your worksheet. If you spreadsheet is “Protected” or being “Shared” with another file, the Data validation tool is turned off in Excel. Possible Reason 1: Protected or Shared – Fix Data Validation Greyed Out

Excel ribbon is greyed out sheet disappeared