Can You Open the Same Excel File Twice?

How-to basics · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, choose View > New Window to open a second window showing the same workbook. Both windows refer to one workbook, so edits appear in both; they are not two independent copies. Opening the file again from another Excel process is different and can lead to a read-only copy or editing conflicts.

What “open the file twice” can mean

The question can describe several different situations, and the distinction matters. You might want two windows to see different worksheets at once, two separate Excel processes, or two independent copies of a workbook. Excel handles those cases differently.

  • Another window of the same workbook: Best for viewing or comparing separate sheets or areas. Both windows share the workbook’s contents.
  • The same file opened in a separate Excel process: This may be blocked, opened read-only, or subject to file-locking and save conflicts, depending on where the file is stored and how it is opened.
  • A second copy of the file: This is an independent workbook only after it has been saved under a different name or location. Changes in one copy do not automatically update the other.

For most people who mean “I want to look at two parts of this spreadsheet at once,” the first option is the right one. It avoids creating duplicate files and keeps the two views connected to the same workbook.

Open a second window of the same workbook

In Excel for Microsoft 365 on Windows, open the workbook and select View > New Window. Excel creates another window for that workbook. You can then select a different worksheet tab in the new window, or scroll to another area of the same sheet. The original window remains available, and you can switch between them from the Windows taskbar or with the usual window-switching shortcuts.

To see both windows at the same time, use View > Arrange All, then select a layout such as Vertical or Horizontal. If you have only the two workbook windows open, this makes it easier to compare them. You can also choose View > View Side by Side when you want Excel to position two open workbooks or windows for comparison. If scrolling in the two views moves them together and you want independent scrolling, turn off Synchronous Scrolling on the View tab.

On a Mac, use Window > New Window to create another window of the active workbook. Menu wording and window arrangement can differ slightly across Mac versions, but the principle is the same: create another view of the workbook rather than opening a second editable copy. Excel for the web does not provide the same desktop window controls; you can open a cloud workbook in another browser tab, but both tabs still point to the same online file.

When multiple windows exist, Excel may show a number after the workbook name in the title bar, such as a “:1” or “:2” suffix. Those labels identify workbook windows, not separate files. Closing one window does not necessarily close the workbook if another window for it is still open.

What happens to edits in each window

The two desktop windows are views of one workbook in memory. If you type a value in a cell in one window, the other window reflects the change as well. There is no separate save operation for each view: saving the workbook saves its current contents, including edits made through either window.

This shared behavior is useful when checking a calculation or tracing data. For example, put a summary sheet in one window and the detailed sales sheet in the other. You can compare a total with its source rows without repeatedly switching sheets. You can also view the top of a long worksheet in one window and a later section in the other.

Because both windows share the same workbook, they are not a safe way to preserve an unchanged version while experimenting. If you overwrite a formula in one window, the change is part of the shared workbook and will show in the other. Use File > Save As to create a separately named copy before making changes you may need to keep apart from the original.

Same Excel process versus a separate process

Opening a workbook a second time through View > New Window is different from starting another Excel process and opening the same path again. In the first case, Excel intentionally makes another view of the already-open workbook. In the second, Excel may treat the file as already in use. Depending on the file location, Excel version, and how it was launched, the second process may reuse the open workbook, show a read-only version, or warn that another user has the file open.

A separate process does not guarantee an independent, safely editable copy. A local workbook can have a lock file while it is open, helping Excel indicate that the file is in use. If two processes both appear able to edit, their changes may not combine cleanly: one save can conflict with or overwrite changes made through the other. Avoid relying on simultaneous independent editing of the same local file.

If you genuinely need a separate working version, save a copy with a distinct name, such as QuarterlyReport-review.xlsx, and make clear which file is authoritative. This is more predictable than attempting to bypass Excel’s file-use behavior. It also makes it easier to compare versions later.

Files on OneDrive, SharePoint, or a network

Cloud-stored workbooks have a different collaboration model from a local file. Excel can support co-authoring for compatible workbooks saved in OneDrive or SharePoint when users have suitable access and use supported versions. In that case, more than one person—or more than one window—can work with the online workbook, and supported changes are synchronized. Co-authoring is not the same as creating two independent copies.

Network folders and locally synchronized folders can behave differently from a workbook opened directly from OneDrive or SharePoint. A sync icon or a file being visible in a cloud folder does not by itself guarantee that a particular workbook is currently co-authoring successfully. If Excel reports that a file is locked, read-only, or unable to merge changes, follow that message rather than assuming both copies will reconcile automatically.

Before making important edits, check the workbook’s location and the status shown in Excel. If your goal is collaboration, share the cloud-hosted workbook with the other editors and have them open that shared file. If your goal is private experimentation, make a separate copy instead. These approaches reduce uncertainty about which edits will be retained.

Useful ways to compare two views

A second window can solve several common viewing problems without duplicating workbook data. After creating it, choose the sheets or ranges that make the comparison useful. For example:

  • View a dashboard in one window and its source table in another.
  • Keep a formula cell visible in one window while inspecting the referenced rows in the other.
  • Compare two worksheets in the same workbook, such as this month’s figures and last month’s.
  • Look at the beginning and end of a long worksheet at the same time.

For a comparison that fits in one view, Excel’s View > Split command divides a worksheet window into panes. View > Freeze Panes is better when you want headings or identifier columns to remain visible while scrolling. These options do not make another file: they change how the worksheet is displayed. Use New Window when you need different sheets or substantially different parts of the workbook visible at once.

Common problems and how to fix them

New Window appears to show the same sheet. That is expected initially. Select a different sheet tab or scroll in one window to create the comparison you want. The windows share workbook data, but each can display a different location.

Changes appear in both windows. This is normal for two views of one workbook, not evidence that Excel duplicated the file. If you need edits to stay separate, use Save As and work in the newly named copy.

The second opening says Read-Only or Locked. Check whether the workbook is open in another Excel process, being edited by another person, or stored in a location that applies file locks. Close the other session if appropriate, or coordinate with the other editor. Do not remove lock files while Excel may still be using the workbook.

You cannot find the other window. Check the taskbar for another Excel window, or use the Window menu to switch between open workbooks and windows. On Windows, Alt+Tab switches between open apps and windows; on Mac, Command+Tab switches apps, while Command+` can cycle through windows of the active app in many configurations.

The two copies show different data. They may actually be separate files with similar names or different folder paths. Check the workbook title and use File > Info or Save As to verify the location. A workbook copy saved under another name will not automatically stay synchronized with the original.

Frequently Asked Questions

Can I open the same Excel file twice and edit both?
Yes, using View > New Window gives you two views you can edit, but both views change the same workbook. Opening separate processes or asking other people to edit a local file at the same time can cause read-only restrictions or save conflicts.

How do I view two sheets from the same workbook side by side?
Open the workbook, choose View > New Window, and select a different worksheet tab in one of the windows. Then use View > Arrange All or View > View Side by Side to position them on screen.

Will a change in one Excel window appear in the other?
Yes. When both windows were created from the same open workbook, they share its contents. A change made in either view is a change to that workbook.

Can two people open the same Excel file at the same time?
They may be able to co-author a compatible workbook stored in OneDrive or SharePoint, subject to access and version support. A local or network workbook may instead be locked or opened read-only. For collaboration, use the shared cloud workbook rather than emailing around competing copies.

How do I make two independent Excel files?
Use File > Save As and choose a different name or folder for the second file. Check the title and save location before editing; the two files will no longer synchronize automatically.

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.