Office Apps Not Opening

How to Fix Cannot Open a Second Excel Workbook While Editing

Bushra Parveen Sep 25, 2026 869 views

Question details

The user is unable to open a second Excel workbook from File Explorer while actively editing a cell in another open workbook.

Fix: Cannot Open a Second Excel Workbook While Editing Another

Product: Microsoft Excel
Device & OS: not provided
Scenario: Trying to open multiple workbooks simultaneously while working on data entry.
Observed behavior: The second Excel file fails to launch or open if a cell in the first workbook is currently in edit mode.

Before you start

Check if your cursor is currently blinking inside a cell or the formula bar of your open Excel workbook, as this temporarily locks the application from opening new files.

Solution 1Recommended

Exit Cell-Edit Mode Before Opening a New File

The most direct way to resolve this issue is to commit or cancel your current cell edits so Excel can process new commands.

Excel prioritizes data integrity, meaning it suspends background tasks like opening new windows to prevent data corruption while you are actively modifying a cell.

Press Enter or Escape

If you are actively typing inside a cell, press the 'Enter' key to save the changes or the 'Escape' key to discard them and exit edit mode.

Select a different cell

Click on any other blank cell in the worksheet to ensure the edit mode is fully deactivated.

Open the second workbook

Navigate to File Explorer and double-click your second Excel workbook. It should now open normally in a new window.

Exit Cell-Edit Mode Before Opening a New File

Success Tip: If you frequently encounter this issue, get into the habit of pressing Enter after typing your data before switching to File Explorer.

Solution 2

Minimize Open Excel Windows

If you cannot easily exit edit mode or the application interface appears unresponsive, minimizing the window forces a background refresh.

Free Microsoft Office alternative

Try WPS Office for Seamless Multi-Document Editing

Tired of Excel locking up when you try to open multiple files? WPS Office offers a free, lightweight, and easy-to-use alternative with a robust tabbed interface that lets you manage multiple spreadsheets without interruption.

1. Download the software: Visit the official WPS website and click the 'Download WPS Office Free' button.
2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to set up the suite on your computer.
3. Open your spreadsheets: Double-click any Excel file to open it in WPS Spreadsheets and experience smooth, tabbed document management.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Tabbed workspace allows you to open and switch between multiple workbooks seamlessly without lock-ups.Free and lightweight, consuming significantly fewer system resources.Familiar user interface ensures a zero-learning-curve migration.

microsoft office alternative - wps office

Frequently Asked Questions

How do I know if an Excel cell is in edit mode?

You can tell a cell is in edit mode if you see a blinking text cursor inside the cell or the formula bar. Additionally, most ribbon commands (like formatting tools) will be greyed out and unclickable.

Why does Excel block opening files during cell editing?

Excel locks the application interface to prioritize data integrity and prevent conflicting commands while a user is actively modifying a cell's contents.

Can I disable edit mode permanently in Excel?

No, edit mode is a core functionality required for inputting data into cells. However, you can disable 'Allow editing directly in cells' via File > Options > Advanced if you prefer to only type data using the formula bar.

Office App Problems