Attempting to open an Excel spreadsheet when another file sharing the exact same name is already open in Microsoft Excel produces a blocking error dialog stating: “A document with the name ‘[filename].xlsx’ is already open. You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either close the document that is currently open, or rename one of the documents.”
This limitation stems from Excel’s fundamental memory architecture. In Excel’s calculation engine, cell formula references across workbooks (e.g. =[Budget.xlsx]Sheet1!A1) are indexed strictly by filename rather than their full folder path. To prevent ambiguous calculation circularities within a single application instance, Excel enforces a strict rule: only one workbook of any given name can exist in memory simultaneously.
| Workaround Approach | Technical Mechanism | Ideal Use Case |
|---|---|---|
| Launch Separate Excel Instance | Executes Excel in completely isolated process memory (/x switch) | Comparing two versions of identically named files simultaneously |
| Rename File with Version Suffix | Appends version or date tag to eliminate name collisions | Archiving or reviewing point-in-time spreadsheet snapshots |
| Open in Excel for the Web | Runs in isolated browser cloud session | Quick verification without modifying local files |
| Terminate Orphaned Excel Processes | Kills ghost background EXCEL.EXE processes holding file handles | Resolving false collision warnings when file appears closed |
Method 1: Force a Separate Excel Instance via Alt + Open
You can force Windows to launch a completely separate process instance of Microsoft Excel (running in its own isolated memory space). Because the two instances do not share formula calculation contexts, both can open identically named workbooks simultaneously.
- Open the first workbook in Excel normally.
- Hold down the Alt key on your keyboard and keep holding it down.
- Right-click the Excel icon on your Windows taskbar and click Excel (or middle-click the icon) while continuing to hold Alt.
- A prompt will appear asking: “Do you want to start a new instance of Excel?”
- Release the Alt key and click Yes.
- In this newly opened Excel window, click File > Open > Browse and select the second identically named workbook.
- Both workbooks will now be open side by side on your desktop.
Method 2: Launch a New Instance via Command Prompt (/x Switch)
The /x command-line switch instructs the Excel executable to spawn a fresh, isolated process bypass.
- Press Windows Key + R to open the Run dialog.
- Type the following command:
excel.exe /x - Press Enter. A new, separate instance of Microsoft Excel will launch immediately.
- Alternatively, open the second workbook directly into a new instance by typing:
excel.exe /x "C:\Path\To\Your\Folder\filename.xlsx" - Press Enter to launch the second file independently.
Method 3: Terminate Orphaned Background EXCEL.EXE Processes
If you closed the first workbook but Excel continues to display “A document with the name is already open”, an orphaned background process or third-party add-in is keeping a phantom lock on the file handle.
- Press Ctrl + Shift + Esc to open Task Manager.
- Under the Processes tab, look under both Apps and Background processes.
- Locate any instances of Microsoft Excel.
- Right-click each Excel process and select End task.
- Once all Excel processes are terminated, double-click your spreadsheet to open it cleanly.
Method 4: View the Second File in Excel for the Web
If you only need to reference or inspect data from the second workbook without modifying local calculation chains, viewing it in your web browser avoids application-level locks entirely.
- Open your browser and navigate to
https://office.live.comorhttps://onedrive.live.com. - Sign in with your Microsoft Account.
- Upload or drag and drop the second workbook into OneDrive.
- Click the file to open it in Excel for the Web.
- The online browser session runs completely independently of your desktop Excel client, allowing simultaneous review.
Method 5: Rename the File Using Structured Versioning
If you are comparing different drafts, revisions, or monthly reports, renaming the file is the cleanest long-term practice to avoid formula link errors.
- In File Explorer, locate the file you wish to open.
- Click the file and press F2 (or right-click and select the Rename icon).
- Append a date stamp or version identifier (e.g. rename
Financial_Report.xlsxtoFinancial_Report_v2.xlsxorFinancial_Report_Nov2026.xlsx). - Press Enter to save the new filename.
- Double-click the file to open both workbooks seamlessly in your primary Excel window.
Safeguards for Cross-Workbook Formula Links
When running two workbooks in separate Excel instances via the /x switch, direct formula cell linking (clicking a cell in Instance A while authoring a formula in Instance B) is disabled because separate processes do not share Dynamic Data Exchange (DDE) handles. If you require live cross-workbook formulas, you must use distinct filenames open within the same primary Excel instance.