excel ribbon is greyed out sheet disappeared

In the Excel Options dialog, select Save. From the File tab in Excel, select Options. Check to make sure you do not have any macros. To allow the use of the PowerPivot ribbon controls in new documents, configure the Save files in this format option to the default setting of Excel Workbook, using the steps below. 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