How to Repair an Excel Workbook After Removing Worksheet Protection
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.

- 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.
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.
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.
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.
Close the file, right-click it in File Explorer, select Properties, uncheck Read-only, and click OK.
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.
Go to the Formulas tab, open Name Manager, and delete external references or defined names that are no longer needed.

Repair the workbook with Open and Repair and save recoverable data
Use this when the workbook still crashes or fails to open after clearing read-only and sharing settings.
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. 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. 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. 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. Remove unused external links and names: Open the Formulas tab, click Name Manager, and delete obsolete external references or defined names.
- 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.

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.




