Updated: August 2018
Applicable: Excel 2019/365/2016; Windows 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.