This 'group' mode can be identified by the following next to the name of the file in the title bar of the window: <filename.xlsx> [GROUP] To remove this, I right-clicked on the active sheet at the bottom of the screen and chose 'Ungroup sheets'. Select "Unprotect Sheet" from "Protection" section of the drop-down menu to unlock the worksheet. Board Regular. why is my excel home ribbon greyed out - jindalhardware.in Select "Unprotect Sheet" from "Protection" section of the drop-down menu to unlock the worksheet. Open your SETTINGS and in the search type in CONTROL PANEL and when a windo. Recently, any Excel file I open has the almost all of the "Home" ribbon greyed out: I can get them to work again by hiding the ribbon and then exposing it again using the arrow to the right of "Share" on the right side of the Title bar. If your chart buttons or Insert Form Contro. You can see there is an editing tab having the following option " Allow changes by more than one user at the same time…". why is my excel home ribbon greyed out Travel Retail Site Soon! Someone here had the same issue a year ago, unresolved. However, that is exceedingly annoying as this now seems to occur for EVERY spreadsheet I open. The HOME ribbon is mostly greyed out when I open excel files. How do I ... Global Duty Free & Travel Retail sales will grow from its preliminary estimate of $46bn last year, to $52bn in 2012. This will open the Share Workbook dialog box. Other possible causes are: Commands are disabled by the administrator. In this video, I look at 7 methods you can use to unlock greyed-out buttons and menu options in Microsoft Excel. excel ribbon greyed out - The Spiceworks Community Tip. Method 1: Enable "Unshare" From The Share Option. disabled (greyed out) ribbon icons - Excel Help Forum