Fix Excel Cells That Cannot Be Edited When Multiple Workbooks Are Open
Question details
The user needs to edit Excel cells reliably while several 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.
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.
Check Excel Editing Settings and Sheet Protection
Use these checks to rule out settings or protection that can prevent editing in a particular workbook.
Open the affected workbook and look for a Protected View banner. If the file is trusted, select Enable Editing.
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.
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.
Click a cell and try typing or pressing F2. If it does not highlight, switch to another workbook window and back, then try again.

Test Workbooks and Add-ins Separately
Use a new workbook and different file combinations to isolate a workbook-specific, add-in, or window-focus issue.
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.

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.




