uftrinity.blogg.se

And the best thing is you don't need a third-party tool to do so. Also, you can quickly zip your excel file in Windows directly from the file explorer. And you can instantly share the zip files with others or even export them to other devices. It compresses your files and takes up less space on your hard drive. So, if you want to unlock the excel workbook, you can easily do it by converting your excel files to zip files. Option 4: Unlock Workbook in Excel via Converting a File to Zip File And that's it! Thanks to our method, the Excel workbook is now unprotected with a password, which works perfectly! And that’s it! We hope you now know how to unprotect excel workbook. So now, when you double-click on the excel file to open, you will find your excel workbook unprotected. Now, tap on the "Select" button to save your excel workbook.Īnd lastly, exit your excel file from the right corner "Close" button.Next, remove the password field and then click on "OK."

Then, you'll see the 4-digit code that you've set before in the "Password box.

Now, you've to select the drop-down arrow of "Protect Workbook" under the option, "encrypt with password." So, to do so, you need to follow the below-mentioned steps.įirstly, select "File > Info." And if your workbook contains a VBA code, you may find here a security warning. And it is the best way to protect your data from others. However, you can also set a password through this option so that people who don't know your password can't access your account. Microsoft Excel's info feature can allow us to remove the protected option from our workbook. Option 3: Unprotect Excel Workbook from Opening