File Corruption & Recovery

How to Repair an Excel Workbook After Removing Worksheet Protection

John WilsonJohn Wilson Nov 13, 2026 868 views

Question details

The user needs to repair a Microsoft Excel workbook that became read-only or crashes after worksheet protection was removed, while preserving formulas and recovering data safely.

How to Repair an Excel Workbook After Removing Worksheet Protection
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user removed worksheet protection from an Excel workbook and now needs to troubleshoot read-only access or crashes without losing formulas.
Observed behavior
The workbook opens as read-only, crashes, or shows lingering external links and defined names after protection was removed.
Before you start

Create a copy of the affected workbook and save it under a new name before making any changes. Confirm the file is not open in another program and that you have permission to edit it.

Solution 1Recommended

Clear read-only and workbook-sharing settings

Use this first when the workbook still opens as read-only after worksheet protection was removed.

After worksheet protection is removed, leftover file attributes or legacy sharing settings can keep the workbook locked or unstable.

1
Save a backup copy under a new name

Open the workbook, click File > Save As, choose a new location or file name, and save it as an Excel Workbook (*.xlsx). Keep the original file untouched.

2
Turn off the read-only file attribute

Close the file, right-click it in File Explorer, select Properties, uncheck Read-only, and click OK.

3
Disable legacy shared workbook editing

Open the saved copy, go to the Review tab, click Share Workbook, and clear the option that allows changes by more than one user at the same time.

4
Remove obsolete external links and defined names

Go to the Formulas tab, open Name Manager, and delete external references or defined names that are no longer needed.

Clear read-only and workbook-sharing settings
Workbook opens normally: The saved copy should now open as an editable workbook while formulas remain intact.
WPS Spreadsheets

Recover the Excel workbook in WPS Spreadsheets

Open the affected workbook in WPS Spreadsheets, remove read-only and sharing restrictions, and save it as a new XLSX to preserve formulas and recover usable data.

  1. 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, click Menu > Open, select the affected .xlsx workbook, and choose to open a copy if prompted.
  2. 2. Clear read-only file attributes: Close the file, right-click it in File Explorer, select Properties, uncheck Read-only, and click OK, then reopen it in WPS Spreadsheets.
  3. 3. Disable shared workbook or review restrictions: In WPS Spreadsheets, go to the Review tab and turn off any shared workbook or track changes options that may keep the file locked.
  4. 4. Remove unused external links and names: Open the Formulas tab, click Name Manager, and delete obsolete external references or defined names.
  5. 5. Save as a new XLSX workbook: Click Menu > Save As, choose Excel Workbook (*.xlsx), save under a new name, and confirm formulas are intact.
Opens and edits Microsoft Excel workbooks without extra convertersSaves in Microsoft Excel XLSX format for full compatibilityFamiliar ribbon interface makes it easy to clear read-only and sharing settingsPreserves formulas and formatting when re-saving as a new workbook
QA img-9

Frequently Asked Questions

Why is my Excel workbook read-only after I removed worksheet protection?

The file system Read-only attribute or a legacy shared workbook setting can still be enabled. Right-click the file, select Properties, uncheck Read-only, and then in Excel go to the Review tab and disable Share Workbook if it is active.

How do I run Open and Repair in Excel?

Go to File > Open > Browse, select the workbook, click the arrow next to Open, and choose Open and Repair. Then select Repair to recover formulas, formatting, and data.

Will saving the workbook as CSV preserve my formulas?

No. CSV files store the calculated values only and do not retain formulas. Save as an Excel Workbook (*.xlsx) to preserve formula structure.

Are third-party password-bypass tools safe for worksheet protection issues?

Avoid them. Unauthorized tools can damage workbook structures and cause read-only or crashing behavior. Use legitimate recovery methods, backups, and Excel's built-in repair options.