Excel Workbook Not Opening? Causes and Fixes for Windows

If an Excel workbook will not open, first try opening Excel in Safe Mode, then use File > Open > Browse > Open and Repair on a copy of the file. The cause may be Excel itself, a damaged or incomplete file, a blocked download, or a security prompt, so identify the message before trying more disruptive fixes.

Start by identifying what is failing

Notice whether Excel starts at all and what happens when you select the workbook. A blank window, an error message, a Protected View banner, and a file that does nothing on double-click point to different problems. If Excel opens other workbooks normally, the trouble is more likely specific to this file or its location. If no workbook opens, investigate Excel, an add-in, or Office installation first.

Record the exact error text and the file extension, such as .xlsx, .xlsm, or .xls. Avoid repeatedly clicking the file or saving over it while diagnosing the issue. If it is important, make a copy before attempting repair. A repair may restore some content but cannot guarantee recovery of every sheet, formula, or formatting detail.

Excel will not start: check whether Excel is already running, then try Safe Mode.
Excel starts, but one file fails: check the file, its extension, and its storage location.
A warning or banner appears: read it before allowing editing or changing security settings.
The workbook opens but looks empty: check for hidden windows or sheets, rather than assuming the file is blank.

Check the file, extension, and storage location

Make sure the download or copy has finished. A file copied from email, a browser, a USB drive, or a network folder may be incomplete if the transfer was interrupted. Compare its size with the sender’s copy if possible; a surprisingly small file can be a clue, though file size alone does not prove corruption. Ask the sender to attach or share it again if the original is available.

Check that the extension matches the file’s actual format. Renaming a PDF or another file to end in .xlsx does not convert it into an Excel workbook. Conversely, a legitimate older workbook may use .xls, and a macro-enabled workbook commonly uses .xlsm. Do not remove an extension warning by changing the name unless you know the file’s real format.

If the workbook is on a network share, removable drive, or cloud-synced folder, copy it to a local folder such as Documents and try opening that copy. This helps distinguish an access or sync problem from damage to the workbook. For OneDrive or SharePoint files, check that syncing has finished and that you can open the file from the service’s website. If it works online but not from the synced folder, the local copy or sync state may be the issue.

If Windows says access is denied, confirm that you have permission to the folder and that another person or process is not holding the file. A workbook being marked read-only usually permits viewing, but prevents saving changes; that is different from Excel being unable to open it. If the file came from the internet, Windows may show a security block in the file’s Properties. Only consider unblocking a file when you trust its source.

Try Excel Safe Mode and check add-ins

Safe Mode starts Excel with many customizations and add-ins disabled. On Windows, press Windows key + R, type excel /safe, and press Enter. If Excel starts this way, try opening the workbook from inside Excel using File > Open > Browse. On a Mac, the Windows Run command is not available; start Excel normally and investigate add-ins or preferences using the controls available in that Mac version.

If the file opens in Safe Mode but not in a normal session, an add-in or startup customization may be interfering. In Windows Excel, go to File > Options > Add-ins. At the bottom, select COM Add-ins next to Manage, choose Go, and clear the check boxes to temporarily disable the listed add-ins. Restart Excel normally and test again. If this fixes the issue, re-enable add-ins one at a time, restarting as needed, to identify the likely cause. You can also check other add-in types from the Manage list.

Safe Mode is a diagnostic step, not a repair to the workbook. If Excel still will not start in Safe Mode, note whether an error appears and move on to Office repair or Windows-level checks. Do not delete files from Excel’s startup folders unless you know what they are; some may be required by your organization or installed software.

Use Open and Repair for a workbook that may be damaged

For a file that Excel cannot read normally, first make a separate copy and work on that copy. In Windows Excel, select File > Open > Browse, navigate to the copy, and select it. Click the arrow beside the Open button, then choose Open and Repair. If prompted, choose Repair first. If repair does not work, reopen the dialog and try Extract Data, which may retrieve values and formulas even if it cannot restore the workbook’s full structure.

After a repair, inspect the result instead of assuming it is complete. Check the sheet tabs, formulas, charts, formatting, external links, and any macros the workbook is expected to contain. Save recovered content under a new name and keep the original untouched. Open and Repair is a Windows Excel feature; the exact recovery options differ on Mac and in Excel for the web.

A workbook saved in a format Excel does not support, or a file whose contents are badly damaged, may not be recoverable through this command. If it is a business-critical file, ask the sender or system administrator for another copy before trying third-party recovery utilities. Avoid uploading confidential workbooks to unfamiliar services.

Understand Protected View and other security prompts

A workbook that opens in Protected View is not necessarily broken. Excel may use this read-only mode for files from the internet or other locations it considers potentially unsafe. If you recognize the sender and were expecting the file, review the source and the warning before selecting Enable Editing. If you do not trust the file, close it rather than bypassing the warning.

Do not turn off Protected View globally just to open one workbook. In Windows Excel, its controls are under File > Options > Trust Center > Trust Center Settings > Protected View, but changing these settings can reduce protection for other files too. If a trusted work file is repeatedly blocked, ask your organization’s IT administrator about the safest way to handle it. A password prompt is also different from a damaged-file error: you need the correct password or help from the file owner to access protected content.

Repair Office if multiple workbooks fail

If several unrelated workbooks fail to open, or Excel behaves abnormally even with a new blank workbook, repair the Microsoft 365 installation. Close Office apps first. In Windows, open Settings > Apps > Installed apps, find Microsoft 365 or Office, select its menu, and choose Modify. Follow the prompts for Quick Repair. If that does not resolve the problem, try Online Repair, which is more thorough and may require an internet connection and a sign-in afterward. Labels can vary slightly by Windows or Office installation.

Repairing Office targets the application, not the contents of a particular workbook, so it is more appropriate when the problem affects multiple files. If the failure continues, install available Office and Windows updates, then restart the computer. On a managed work device, contact IT before changing or repairing the installation; the organization may control updates and Office settings. On Mac, use Microsoft AutoUpdate and the Mac’s available Office troubleshooting steps rather than Windows Settings.

Recover an earlier copy and prevent repeat problems

If repair fails, look for another version before assuming the data is lost. The file owner may have an email attachment, a previous download, or a backup. For a workbook stored in OneDrive or SharePoint, check its version history on the service; the available history depends on the account and retention settings. If AutoRecover was enabled, Windows Excel may list recovery files after a crash. You can also check File > Info > Manage Workbook for recovery options when they are available. Recovery files are not guaranteed, and they may contain only the last saved or automatically recovered state.

For future work, save important files to a location that is backed up, allow cloud syncing to finish before shutting down, and use a suitable workbook format. Use .xlsm when the workbook needs VBA macros; saving a macro-enabled file as .xlsx removes its macros. Keep a separate backup before major edits or repairs. If the workbook repeatedly becomes unreadable on a network drive, ask the administrator to check storage and permissions rather than repeatedly replacing the file.

Frequently Asked Questions

Why does Excel open but show a blank window?
A workbook window may be hidden, Excel may be displaying an empty start screen, or the file may not have loaded correctly. Try View > Unhide if that command is available, and check whether the workbook is listed under Window on the ribbon. If only one file shows a blank window, close it without saving and test a copy using Open and Repair.

Can I open an Excel workbook without Excel installed?
Excel for the web can open many Excel files through OneDrive or SharePoint, subject to file type, size, and feature limitations. Uploading a copy there can help determine whether the desktop application is the issue, but it is not a guaranteed repair and may not support every workbook feature. Other spreadsheet programs can also alter formatting or formulas, so preserve the original.

What does Excel’s file format or extension error mean?
It often means the extension does not match the file contents, the file is incomplete, or its contents are damaged. Confirm the file came from a trusted source and ask for a fresh copy. Simply renaming the extension does not fix a mismatched or corrupted file.

Will Open and Repair restore everything?
No. It can sometimes recover a usable workbook, but some content, formatting, links, or other features may be missing. Work on a copy, inspect the repaired file, and compare it with another version if one exists.

Why will a workbook open on the web but not in desktop Excel?
The desktop app may have an add-in, installation, or local sync problem, while the browser is opening a cloud copy. Check that the local file has finished syncing, test Excel Safe Mode, and compare the web and desktop versions carefully. Do not overwrite the cloud copy with a damaged local file.

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.