The restrict editing in Excel 2007 or up version of Excel is really a good feature to protect the excel file from editing by others.
But in common using, you may meet the two situations:
Situation 1: You want to edit excel file (*.xlsx) that has been created and restricted editing by you for data security, but you forgot the password protection. How to remove restrictions?
Situation 2: You got an edit-restricted excel file from others but you didn't receive the protection password at the same time. So how can you remove edit restrictions in Excel without password?
All the situation result from a reason- forgetting the password.
So here we would show you the ways to remove the edit restrictions in Excel 2007 and its up versions.
Way 1: Remove Edit Restrictions in Excel 2007-2016 with 7ZIP
Step 1: Go and download 7zip at 7 zip official site.
Step 2: Change the corresponding excel file's extention name to be .zip
Step 3: Open the changed file with 7zip. Typically, you can see two types of file:
sheet.xml: includes protection password on sheets
workbook.xml: includes protection password on workbook structure and windows.
Step 4: Select a sheet.xml and rigth click it to open a option list.
Step 5: Press Ctrl + F to open Find dialog in opening XML file and enter "sheetProtection" to find the text. then select and delete tag "sheetProtection" from xml file.
Step 6: Close the xml file and click Save on pop-up dialog to save changes to xml file. Then click OK to update the xml file in zip file.
Note: the way of remove workbook instructure and windows protection password is similar with the way mentioned above. You should just adapt the sheetProtection to workbookProtection.
Step 7: Change the file's extention name back to .xlsx. and open it on read-only mode. Then navigate to File > Save As in MS Excel and enter a new name for the file in Save As dialog. Then click Save button to remove read-only password.
Way 2:Remove Restrict Editing in Excel with Workbook Unprotect Genius
Step 1: Go and download Workbook Unprotect Genius which could remove edit protection password on excel file.
Support excel 2007-2016 (*.xlsx) file only. If you have excel 97-2003 (*.xls)) file, please convert it to xlsx file firstly.
Its trial version only could import protected excel file, but it cannot remove edit restrictions from the file.
Step 2: Import edit-restricted Excel file by clicking Open. and then click the Remove password button to begin password removing process.
Step 3: When a dialog prompts you that the password has been removed, then click OK and you would get an unprotected excel file in the same location of protected excel file. It means you have successfully removed edit restrictions from excel file. Just keep the unprotected excel file in safe place.