Plugavel.
  • Home
  • Tech
  • Car
  • More
    • Privacy policy
    • About us
    • Contact us
No Result
View All Result
Plugavel.
  • Home
  • Tech
  • Car
  • More
    • Privacy policy
    • About us
    • Contact us
No Result
View All Result
Plugavel.
No Result
View All Result

How to remove the protection of an Excel sheet without password?

28 de June de 2021
in Tech
En éditant un fichier de configuration, on peut retirer aisément la protection d’une feuille Excel. © Pixabay.com
ADVERTISEMENT

The famous Microsoft Excel spreadsheet allows you to “Protect a sheet” with a password, to limit the ability to modify or access the formulas of other users. If you don’t have the password for the file, you can unlock it by following this tutorial.

In the “Revision” menu of Microsoft Excel, there is a “protect the sheet” feature. When enabled, users have restricted access to the file. In the event of an attempted unauthorized modification, a window is displayed to indicate that it is necessary to remove the protection with the password.

If you need to unlock the Excel sheet but do not have the password, it is always possible to remove the protection by editing a configuration file. For this, you need to use the free and open source 7-Zip file compression / decompression software. This tool is better than WinZip in its handling of changes to XML files contained in archives.

Make a copy of your file, as a security measure. Make sure that Windows Explorer displays file name extensions, by checking this option in the “View” menu. Then change the extension of the copied file from “.xlsx” to “.zip”. Windows should display a warning that changing the extension may render the file unusable. Confirm with “yes”.

Open the newly created ZIP archive using 7-Zip and go to the xl worksheets directory. There you will find a file named “sheet1.xml”, which must be edited using Notepad. If you cannot open it, check in your Windows settings that this program is correctly configured as applications default for the type of XML file.

The file contains a tag that determines the protection of the Excel sheet. It begins with “

Delete this paragraph and close the document. Confirm the saving of the modified file and update it in the archive (7-Zip will suggest it to you automatically) before exiting 7-Zip.

Since the protection paragraph has been removed from the archive, you must now change the file extension again. This time, change the extension “.zip” to “.xlsx”. You can then open the document using Excel.

Cell modification is now possible. If you want to protect the Excel sheet again, go to the “Review” tab and click on “Protect Sheet”. Enter the new password twice and confirm.

What you must remember

  • Thanks to this tutorial, you now know how to remove password protection from Excel sheet. Make good use of it!

Interested in what you just read?

ShareTweetPin

We would like to send you notifications with news, you can unsubscribe at any time.

Unsubscribe

Recommended

Samsung Galaxy S22: take advantage of the pre-order offer for this new smartphone!

27 de February de 2022

Tesla Superchargers arrive at Casino

14 de February de 2022
Spa-Francorchamps: the legendary Raidillon chalet destroyed to gain space

Spa-Francorchamps: the legendary Raidillon chalet destroyed to gain space

17 de October de 2021
Tesla: huge investment for the Semi factory

Tesla: huge investment for the Semi factory

25 de January de 2023
  • Home
  • Privacy policy
  • About us
  • Contact us
© 2021 Plugavel - News about technology and cars on one site Plugavel.
No Result
View All Result
  • Home
  • Tech
  • Car
  • More
    • Privacy policy
    • About us
    • Contact us