Excel Workbook Open: Opening Files and Fixing Issues

To open an existing Excel workbook in Microsoft Excel for Microsoft 365 on Windows, start Excel and choose File > Open > Browse, select the workbook, and click Open. You can also press Ctrl+O, browse to the file, and open it. If you meant to check whether a workbook is already open, look for its name in Excel’s title bar or switch among open workbooks from the View tab.

What an Excel Workbook Is

A workbook is the Excel file itself. It can contain one or more worksheets, which are the individual spreadsheet tabs with rows, columns, cells, formulas, and data. For example, a file called Quarterly Budget.xlsx might contain separate worksheets for each quarter. Opening the workbook makes its sheets available in Excel; it does not mean that every sheet is displayed at once.

Excel is the application, while the workbook is a file that the application opens. This distinction helps when troubleshooting: Excel can be running without any workbook open, and a workbook can be open in Excel but hidden behind another window. If Excel is already running, check its title bar and the View tab for other open workbook windows. On Windows, Alt+Tab also switches between open application windows, though it may not distinguish workbooks if they are displayed in one Excel window.

Open a Workbook from Excel

The File > Open route is useful when you want to choose a specific file or confirm its location. In Excel for Microsoft 365 on Windows:

Open Excel. If the start screen appears, choose Open. If a workbook is already displayed, choose File > Open.
Choose Browse to open the Windows file picker. Select the folder containing the workbook.
Select the file and choose Open. If the file is in a cloud location, you may need to sign in to the relevant Microsoft account first.

Ctrl+O is the Windows shortcut for opening the Open page. From there, Browse lets you find a file stored on your computer or on an accessible drive. Excel may also list recent files; selecting one can be quicker, but a recent-file entry is not proof that the file is still in the same location or that you have permission to open it.

On a Mac, use File > Open or press Command+O, then choose the workbook in the macOS file picker. The labels and layout of the picker differ from Windows, but the basic process is the same. Excel for the web uses a browser rather than the desktop file picker; open the workbook from OneDrive or SharePoint, or upload it to a supported location.

Other Ways to Find and Open the File

If you know where the workbook is saved, you can open it from File Explorer on Windows or Finder on Mac. Double-clicking an Excel file usually launches Excel or brings it to the front. The result depends on the computer’s file-association settings: another spreadsheet program may open the file if it is set as the default for that file type. Right-clicking the file and choosing Open with lets you select Excel when it is installed.

For a workbook stored in OneDrive or SharePoint, you can open it from Excel’s recent files, from the relevant folder in the cloud service, or from a shared link. A work or school account may require you to sign in and may limit access based on the file owner’s permissions. If a link opens in a browser, look for an option to open the file in the desktop app when you need desktop Excel features. In Excel for the web, many common spreadsheet tasks work in the browser, but some desktop features and connections may not be available or behave differently.

If you cannot remember the folder, search for the filename in File Explorer or Finder. Searching for a distinctive part of the name is often more effective than searching for a generic term such as budget. Check the file extension as well: a downloaded copy may have a similar name but be in a different folder from the original.

File Types and What Happens When They Open

The extension at the end of a filename gives a useful clue about the file’s contents and behavior. Common Excel-related file types include:

.xlsx: The standard modern Excel workbook format. It does not store VBA macros.
.xlsm: An Excel macro-enabled workbook. It can contain VBA code, but opening it does not mean macros should automatically be trusted.
.xls: The older Excel 97–2003 workbook format. Some newer features may not be supported when saving in this format.
.xlsb: An Excel binary workbook format. It can support macros and may be used for large or complex workbooks.
.csv: A text file containing delimited data. It normally represents one table or sheet of data, not a full workbook with multiple worksheets, formatting, and formulas.

When Excel opens a CSV file, it may interpret values according to regional settings, including the delimiter and decimal symbol. It can also remove features that a CSV cannot store if you save the data back to CSV. If you need multiple sheets, formatting, or formulas, save the file as an Excel workbook format such as .xlsx rather than treating CSV as an interchangeable workbook format.

Excel may show a compatibility notice when an older format cannot retain all features. Read the notice before saving changes. If preserving all modern workbook features matters, save a copy in .xlsx or, when the workbook contains macros, .xlsm format, provided you are authorized to keep those macros.

Security Prompts and Protected View

A workbook downloaded from the internet, received by email, or located in another potentially unsafe location may open in Protected View. This is a read-only mode intended to reduce risk from files that could contain harmful content. A yellow message bar may offer an Enable Editing button. Only enable editing after you have checked that the file and its source are trustworthy.

Macro-enabled files can also display a security warning about macros. Macros are programs that can automate tasks, but they can also perform unwanted actions. Do not enable macros simply because a workbook asks you to. Confirm the sender and expected purpose, and follow your organization’s security guidance. A file being a familiar type, such as .xlsm, is not by itself evidence that its contents are safe.

If Excel says a file is blocked or that you do not have permission, do not bypass the warning without understanding why it appears. The file may be managed by an organization, restricted by its owner, or flagged because of where it came from. Ask the file owner or your IT administrator for access when appropriate.

When a Workbook Will Not Open

First check the simple causes: confirm that you selected the right file, that the file has finished downloading, and that the storage location is available. A workbook on an external drive or network share may fail to open if the drive is disconnected or the network is unavailable. For a cloud file, check your internet connection and account sign-in, then try opening it from the service where it is stored.

If Excel reports that the file format or extension is not valid, the extension may not match the file’s actual contents, or the download may be incomplete. Avoid renaming the extension as a first fix: changing a filename from one extension to another does not convert its contents. If the file came from someone else, ask them to resend it in a supported format. If it is important, keep an untouched copy before attempting recovery.

For a file that appears damaged, Excel for Windows has an Open and Repair option in the Open dialog. Choose File > Open > Browse, select the workbook, then use the arrow beside the Open button and choose Open and Repair if that option is available. Excel may offer Repair or Extract Data. Repair tries to recover workbook contents; extracting data may recover values and formulas while losing some formatting or other features. Work on a copy where possible, because recovered content may not match the original exactly.

If Excel opens but the workbook is hard to find, the window may be behind another application, minimized, or displayed on another monitor. Use the taskbar or Alt+Tab on Windows to locate it. In Excel, the View tab can help you switch among open windows. If a workbook window has been hidden, check the View tab for the Unhide command; it is available only when a workbook window is hidden. A hidden window is different from a closed workbook, so do not assume the file needs to be opened again before checking.

Read-Only, Editing, and Multiple Copies

A workbook may open as read-only because another person is editing it, because the file is marked read-only, or because your account has viewing rather than editing permission. Read-only access lets you inspect the contents without saving changes over the original. If you need to make edits, check with the file owner or use Save As to create a separate copy when your permissions and the workbook’s terms allow it.

Cloud workbooks can support co-authoring, in which multiple people edit the same file, but access and behavior depend on where the file is stored, the account, and the Excel version. A file saved only on a local drive does not automatically become a shared, live document. Before editing a shared workbook, check that you opened the intended copy and location; a locally downloaded attachment may be separate from the cloud original.

If you see a message that the workbook is locked for editing, another user or another session may have it open. In a shared location, wait or contact the other editor rather than making a competing copy without checking. In other cases, Excel may leave a temporary lock file after a crash or interrupted session. Close other Excel sessions and confirm that no one else is actively editing before asking an administrator to investigate or removing any temporary files.

Opening in Excel or Using an Alternative

Excel desktop is often the best choice when a workbook uses advanced features, external data connections, macros, or detailed formatting. Excel for the web is convenient for files in OneDrive or SharePoint and for quick collaborative edits, but not every desktop feature is supported in the browser. If a workbook behaves differently online, opening it in the desktop app may provide additional tools; it does not guarantee that every connection or feature will work without setup.

Other spreadsheet programs may open some Excel formats, but complex formulas, macros, charts, or layout details can change when a file is opened or saved in a different program. For a file that must remain faithful to its original Excel behavior, use Excel when possible. For simple tables, another compatible spreadsheet app may be sufficient, but keep an original copy before saving changes in a different format or program.

Frequently Asked Questions

How do I open an Excel workbook without Excel already running?
Double-click the workbook in File Explorer on Windows or Finder on Mac. If Excel is installed and associated with that file type, it should launch and open the workbook. Otherwise, right-click the file, choose Open with, and select Excel.

How can I tell whether a workbook is already open?
Check Excel’s title bar for the workbook name and use the View tab to switch among workbook windows. On Windows, Alt+Tab can also help locate an Excel window. If the window is hidden, check View > Unhide when available.

Why does my workbook open in read-only mode?
It may be locked by another editor, marked read-only, opened from a protected location, or shared with view-only permissions. Check the message Excel displays and confirm your access with the file owner before trying to overwrite or replace the original.

Can I open an Excel workbook in a browser?
Yes. Excel for the web can open supported workbooks stored in OneDrive or SharePoint. Some desktop features may be unavailable or work differently, so use the desktop app when a required feature is not supported in the browser.

What should I do if Excel says the workbook is corrupted?
Keep an original copy, then try Open and Repair from Excel’s Windows Open dialog. If repair fails, use Extract Data if offered, or ask the sender for another copy. Recovery can lose formatting or other workbook features, so verify recovered content before relying on it.

Does changing .csv to .xlsx convert a file?
No. Renaming the extension alone does not convert the file’s contents. Open the CSV in Excel and use Save As to create an Excel workbook if you need a genuine .xlsx file, then check that the imported data looks correct.

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.