Document Editing Problems

Fix Excel Cells That Cannot Be Edited When Multiple Workbooks Are Open

Huda QurayshiHuda Qurayshi Nov 14, 2026 868 views

Question details

The user needs to edit Excel cells reliably while several workbooks are open.

Fix Excel Cells That Cannot Be Edited When Multiple Workbooks Are Open
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user typically works with three to five open workbooks and needs to switch between them and edit cells.
Observed behavior
Cells sometimes cannot be edited or do not highlight until the user switches to another workbook and back. Closing a workbook can restore editing, but Office repairs and reinstalls have not resolved the issue across multiple computers.
Before you start

Identify which workbooks are open when the issue occurs and note whether cells fail to highlight or only fail to enter edit mode. Save any pending changes before closing workbooks for testing.

Solution 1Recommended

Check Excel Editing Settings and Sheet Protection

Use these checks to rule out settings or protection that can prevent editing in a particular workbook.

1
Check for Protected View

Open the affected workbook and look for a Protected View banner. If the file is trusted, select Enable Editing.

2
Check sheet protection

On the affected sheet, open the Review tab. If Unprotect Sheet is available, select it and enter the password if prompted; otherwise, ask the workbook owner for editing access.

3
Enable in-cell editing

On Windows, go to File > Options > Advanced and check Allow editing directly in cells. If this option is off, you can still edit a selected cell using the formula bar.

4
Test cell selection

Click a cell and try typing or pressing F2. If it does not highlight, switch to another workbook window and back, then try again.

Check Excel Editing Settings and Sheet Protection
Workbook protection versus sheet protection: Workbook structure protection restricts changes to sheets, such as adding or moving them. Sheet protection is the setting more directly associated with restricting cell edits.
Free Microsoft Office alternative

Work With Multiple Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format compatibility helps you move existing files into your workflow, although it does not repair the Excel issue.

Open and edit multiple spreadsheet workbooksCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for easier migrationFree and lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why can I edit a cell in the formula bar but not directly in the cell?

In Excel for Windows, check File > Options > Advanced > Allow editing directly in cells. When this option is disabled, the formula bar can still be used to edit the selected cell.

How can I tell whether a sheet is protected?

Open the Review tab in the affected workbook. If Unprotect Sheet is available, the sheet is protected; you may need a password from its owner to remove the restriction.

What should I do if a cell does not highlight when I click it?

Switch to another workbook window and back, then try selecting the cell again. If that helps, test the same files one at a time and note which combination reproduces the focus issue.

Can an Excel add-in cause problems when several workbooks are open?

An add-in conflict is one possible cause. In Excel for Windows, go to File > Options > Add-ins, select COM Add-ins under Manage, and choose Go. Temporarily disable enabled add-ins, restart Excel, and test them one at a time.