Updated: October 2019
Applicable: Microsoft Excel 2019/365/2016; Windows and macOS operating systems.
Here’s a question we got:
Dear Team – some time ago i have created a quite sophisticated Excel spreadsheet for my manager which i password protected for increased security. The thing is that it seems that i have forgotten the password which i previously set. So i guess my questions is whether i can reset the workbook password protection since i have forgot it? Many Thanks!
As we just saw, in Microsoft Office we are able to set a password protection for our Excel files. In this tutorial , we’ll learn how to reset those spreadsheet protection password so you can edit the file contents. Although we are focusing on Excel in this post, the explanation below is mostly applicable to Word and PowerPoint files as well.
In Excel 2016, there are three main ways to secure contents in a spreadsheet:
The method for un-protecting each is described below.
In order to make changes to the structure of a protected (not encrypted) workbook, you need to unlock it first. Here’s how to:
Hope it helps!