Excel Workbook Greyed Out? Causes and Fixes

How-to basics · Updated November 18, 2026

If an Excel workbook is greyed out in the Open dialog, check the file-type filter first: choose File > Open > Browse, then change “Files of type” to an Excel format or All Files. If the workbook is open but Excel controls or cells are greyed out, the cause is more likely a protected sheet, a hidden workbook window, a dialog that needs attention, or a command that is unavailable in the current context.

“Greyed out” can describe several different things, and the right fix depends on what is actually dimmed. A file you cannot select in a file picker is different from a disabled ribbon button or a grey worksheet area. Start by identifying which part of Excel is grey, then use the matching checks below rather than changing workbook settings at random.

When the workbook file is greyed out in Open

In Excel for Microsoft 365 on Windows, go to File > Open > Browse to display the Windows file picker. Near the bottom of that dialog, the “Files of type” setting filters which files Excel displays or lets you select. If it is set to a particular format, a file with another extension may look dimmed or may not appear. Select an appropriate Excel workbook format, or choose All Files (*.*), and see whether the file becomes selectable.

Excel workbooks commonly use .xlsx, .xlsm, .xlsb, or the older .xls extension. A file with a different extension might be a CSV, a text file, or a format created by another spreadsheet application; seeing it after changing the filter does not guarantee that it contains a valid Excel workbook. Select it only if you recognize the file and expect Excel to open that format. Excel may show a warning or import prompt for some file types.

If you are opening a file from OneDrive, SharePoint, a network folder, or a removable drive, check that the file is available and that you have access. A cloud-only file may need to download before it opens; a shared or network file may be read-only or locked by another person. Try opening the file from its normal location, and, if appropriate, ask the owner for permission. Do not rename a file extension simply to make it appear in the picker: changing the name does not convert the file’s contents.

Why Excel commands or cells are disabled

When the workbook is open, grey ribbon commands usually mean Excel cannot perform that action in the current state or selection. For example, a command may require a cell range, a chart, or a particular worksheet to be selected. Some commands are also unavailable while you are editing a cell, while a dialog box is open, or while a feature is processing. Press Esc to leave cell editing or close a dialog that is waiting for a response, then check whether the command becomes available.

Look at the whole window before assuming the workbook is damaged. A message bar, password prompt, or confirmation dialog may be waiting behind another window. Use Alt+Tab on Windows to check for another open Excel dialog or window. If Excel is busy recalculating or responding to a large operation, give it time before clicking repeatedly. On a Mac, use Command+O to open a file, and check for a dialog in front of the workbook in the same way.

Selection also matters. Some Home, Insert, or chart commands become available only after you select a relevant cell, range, object, or chart. If a command remains dimmed, click a normal cell and inspect the Review tab for protection indicators. A disabled command is not, by itself, evidence that the entire workbook is locked.

Check sheet and workbook protection

Worksheet protection is a common reason that cells cannot be edited or particular commands are unavailable. On Windows, select the affected worksheet and open Review. If the button says Unprotect Sheet, protection is active; choose it and enter the password if you are authorized and have it. If the button says Protect Sheet, the sheet is not currently protected. Protection can be configured to allow some actions while blocking others, so a protected sheet may still let you select cells or use permitted features.

Workbook-structure protection is different from sheet protection. It can prevent actions such as adding, deleting, moving, hiding, or renaming worksheets. Check Review > Protect Workbook. If the workbook is protected, Excel may request a password to turn that protection off. A password-protected feature cannot be legitimately bypassed by changing a display setting; contact the workbook owner or your organization’s administrator if you need access.

Protection is not the same as read-only access. A read-only workbook may let you view and copy data while preventing you from saving changes to the original. Check for a Read-Only notice, an editing restriction, or a prompt to save a copy. If you have permission to edit, use Save As to create a separate copy in a location where you have write access. This preserves the original and avoids overwriting another person’s work.

Look for a hidden workbook window

Sometimes Excel is running and the workbook is open, but its window has been hidden. The result can look like a grey or empty Excel workspace rather than a normal spreadsheet. In Excel for Microsoft 365 on Windows, select View > Unhide if that command is available, then choose the workbook window in the list. If Unhide is unavailable, Excel may have no hidden workbook window to restore.

Also check whether the workbook is minimized or behind another Excel window. Use the taskbar to switch between open workbooks, or use Alt+Tab to locate the one you want. If the workbook window is visible but the worksheet itself is hidden, look at the sheet tabs: right-click a visible tab and choose Unhide if that option is available. This concerns a hidden worksheet, not a grey file in the Open dialog. A hidden sheet may also be controlled by workbook-structure protection.

Protected View, read-only files, and access warnings

Files downloaded from the internet or received through email may open in Protected View. Excel displays a warning bar and limits editing until you choose Enable Editing. Only do that when you trust the file and its source; Protected View is a security precaution, not a routine error message to dismiss automatically. If there is no warning bar, Protected View may not be the reason cells or buttons are disabled.

Files can also be read-only because of file permissions, an organization’s sharing policy, or another user’s editing session. A workbook may open normally while changes cannot be saved to the same location. Check the title bar and any message above the worksheet, and confirm that you have permission to edit the file and its folder. For a shared workbook, ask the owner whether another person has an exclusive lock or whether your access is view-only.

Do not confuse a greyed-out command with Excel’s account activation or licensing status. If Excel reports that the product is unlicensed or that editing is disabled, follow the sign-in or activation message shown in Office. That situation can affect editing across documents and is not usually fixed by changing the workbook’s protection settings.

A practical troubleshooting order

These checks help separate a file-selection problem from a workbook-state problem:

  1. Identify what is grey. Is it the filename in a picker, the cells, a worksheet tab, or a ribbon command?
  2. If it is a filename, check the filter. Use File > Open > Browse and set “Files of type” to a suitable Excel format or All Files.
  3. If the workbook is open, clear temporary states. Close prompts, press Esc to exit cell editing, and select an ordinary cell.
  4. Check protection and access. Look at Review > Protect Sheet and Review > Protect Workbook, plus any read-only or Protected View notice.
  5. Restore the window. Check View > Unhide and switch among open Excel windows.
  6. Try a safe copy if permitted. Use Save As to a writable location, or ask the owner or administrator to confirm your access.

If the problem affects only one workbook, compare it with another file in Excel. If the same controls are disabled in several workbooks, the cause may be Excel’s current state, an Office sign-in or licensing message, or an organization-wide restriction. If the file will not open after it becomes selectable, note the exact error and preserve an untouched copy before attempting recovery or conversion.

Common misconceptions and useful distinctions

A grey filename does not necessarily mean the workbook is corrupt. It may simply be excluded by the file picker’s filter. Likewise, a grey ribbon button does not necessarily mean the workbook is protected: the command may not apply to the current selection, or Excel may be waiting for a dialog or cell edit to finish.

Another frequent mix-up is sheet protection versus workbook protection. Sheet protection controls changes within a worksheet; workbook-structure protection controls changes to the sheet arrangement. Read-only access controls whether you can save edits to a particular file location. Protected View limits editing because of a security warning. These states have different indicators and different remedies, so check the message or Review tab rather than treating them as interchangeable.

On Excel for the web, the file picker and some ribbon controls differ from the Windows desktop application, and certain desktop commands are not available there. If a command is missing or disabled in a browser, open the workbook in the desktop app if your account and permissions allow it, then check the equivalent protection or access setting. The underlying file’s sharing permissions still matter regardless of which version you use.

Frequently Asked Questions

Why is my Excel file greyed out when I try to open it?
Most often, the Open dialog’s file-type filter excludes it. In File > Open > Browse, change “Files of type” to the relevant Excel format or All Files. If the file still cannot be selected, check its location, permissions, and extension.

Why are cells greyed out and not editable?
Check for a Protected View or read-only message, then open Review > Protect Sheet. A protected sheet may block editing, while a read-only file may prevent saving changes to the original. You need the appropriate permission or password to remove those restrictions.

Why is Excel’s ribbon greyed out?
Excel may be editing a cell, waiting for a dialog response, or showing a command that does not apply to your selection. Press Esc, close any open prompt, and select a relevant cell or object. If only certain actions are blocked, check sheet or workbook protection.

How do I unhide a workbook in Excel?
In the Windows desktop app, choose View > Unhide and select the workbook if it appears in the list. If the command is unavailable, there may be no hidden workbook window. A hidden worksheet is a separate issue and may be restored from a sheet tab’s Unhide command.

Does a greyed-out Excel workbook mean it is corrupted?
No. A file filter, access restriction, hidden window, or protection setting can make a workbook appear unavailable without indicating corruption. If Excel displays a specific opening or repair error, keep a copy of the original and use that message to guide the next step.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.