Office Apps Not Opening

Fix Excel Says a Second Workbook Is Open but Cannot Be Found

Maira Mehtab Sep 22, 2026 870 views

Question details

The user receives an error in Excel stating that two workbooks with the same name cannot be open simultaneously, yet the duplicate workbook is not visible on the screen.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to open an Excel workbook.
Observed behavior: Excel displays an error that a second workbook is open, which cannot be found visually but appears in the Switch Windows menu.

Before you start

Ensure you have saved all currently visible workbooks before troubleshooting to prevent any accidental data loss.

Solution 1Recommended

Restart Computer and Open File Directly

Use this method if the issue only affects a single specific file.

A system restart can clear out ghost processes where Excel thinks a file is still open in the background.

Restart the computer

Close all open applications and restart your computer to clear any background Excel processes.

Open a blank workbook

Launch Microsoft Excel and open a completely new, blank workbook.

Browse to the file location

Navigate to 'File' > 'Open', click on 'Browse', find the specific location of your workbook, and open it directly from there.

File Locks: Opening the file from within Excel rather than double-clicking it in File Explorer can sometimes bypass temporary file locks.

Solution 2

Unhide Workbooks and Check Views

Sometimes the duplicate workbook is open but hidden from the main view.

Solution 3

Repair or Reinstall Microsoft Office

If the error occurs with every workbook you try to open, there may be an issue with your Office installation.

Free Microsoft Office alternative

Switch to WPS Office to Avoid Excel Errors

Experiencing frequent workbook errors in Microsoft Excel? Try WPS Office, a free, lightweight, and highly compatible alternative that offers seamless spreadsheet management without the hefty price tag or common installation glitches.

1. Download WPS Office: Download and install WPS Office for free from the official website.
2. Open your file: Right-click your troublesome Excel file and select 'Open with' > 'WPS Office'.
3. Edit seamlessly: Enjoy seamless spreadsheet editing with 100% format compatibility and no phantom workbook errors.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free and lightweight, consuming fewer system resources and preventing background hangs.Tabbed viewing interface prevents multiple window confusion and hidden workbook errors.Familiar user interface requires no learning curve to switch.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say a workbook is open when it isn't visible?

This often happens due to background Excel processes that haven't closed properly, hidden windows in the View settings, or temporary file conflicts left over from a previous crash.

How do I forcefully close hidden Excel background processes?

Press Ctrl + Shift + Esc to open the Task Manager, locate 'Microsoft Excel' under the Processes tab, right-click it, and select 'End task'.

Where can I find hidden workbooks in Excel?

Navigate to the 'View' tab on the top ribbon and look for the 'Unhide' button in the Window group. Clicking this will list any hidden workbooks you can restore to visibility.

Can an Excel add-in cause the phantom workbook error?

Yes, certain incompatible or outdated add-ins can interfere with how Excel manages windows. Try opening Excel in Safe Mode by holding the Ctrl key while launching the app to see if an add-in is the culprit.

Office App Problems