This article explains how to unprotect Excel workbooks. The information applies to Excel workbooks in Microsoft Excel 365, Microsoft Excel 2019, 2016, and 2013.
How to Unprotect Excel Sheets and Workbooks | 3 Ways to Unprotect an Excel File with a Password
Microsoft Excel is packed with features. One of those features is the ability to protect your Excel files at the cell, spreadsheet, or workbook level. Sometimes it is necessary to remove protection from Excel workbooks to ensure that data changes are applied correctly.
This method assumes that you, as the owner of the file, know the password used to protect the spreadsheet.
Open the protected spreadsheet and select Review > Unprotect Sheet. Alternatively, right-click the protected spreadsheet and select Unprotect Sheet.
