I don’t want the “open password” of the Excel table, how to cancel it?

php editor Baicao teaches you how to cancel the "open password" of Excel tables! If you no longer want to password-protect your Excel spreadsheet, you can cancel the password with a simple operation. Just open the Excel sheet, click "File" -> "Information" -> "Protect Workbook" -> "Encrypt Password", enter the current password, leave the password box blank, and save to cancel the "Open Password" setting. In this way, you can easily cancel the "open password" function of Excel tables, allowing you to manage and share table files more conveniently!

If the subsequent forms no longer need to be protected, you will have to enter the password every time you open it, which is also very troublesome.

So if you don’t want to “open password” but remember the password, how to cancel the “enter password” step? (If you forget your password, you can go directly to the last method.)

For those who don’t know, let’s take a look at how to operate.

method one:

1. Because the "open password" is set, we need to enter the password first to open the Excel table before we can operate.

.

2. After opening the Excel table, click the menu [File] option, and then select [Information]-[Protect Workbook]-[Encrypt with Password].

.

3. After the [Encrypted Document] dialog box pops up, you can see that there is already a password in the password field. Delete the password into a blank space, then click [OK] and save the form. The password will not exist next time you open Excel. .

.

Method Two:

1. Also enter the password to open the Excel table, then click the [File] option in the menu, then click [Save As], and then select the save path on the right.

.

2. After the [Save As] dialog box pops up, click the [Tools] option below, and then click [General Options] in the list below.

.

3. The [General Options] dialog box pops up, and you can see that there is already a password in the [Open Permission Password] column. Delete the password, and then click [OK]. Then save the table, you can directly overwrite the original Excel table, or you can change the name and save it as a new table. Once completed, there will be no password for Excel.

.

Method 3:

As can be seen from the previous methods one and two, to cancel the password, you need to open the Excel table with the password and then cancel it. If you forget the password, you cannot open the Excel table and you cannot cancel the password directly.

In this case, we might as well try using tools to solve the problem. Although we cannot cancel the password directly, it can help us get back the "open password" of Excel.

Take the Pepsi Niu Excel password recovery tool as an example, click the [Retrieve Password] module in the tool, and then import the Excel table,

Tool link:PepsiNiu Excel Password Recovery Tool

Just wait for the password to be retrieved later.

The above is the detailed content of I don’t want the “open password” of the Excel table, how to cancel it?. For more information, please follow other related articles on the PHP Chinese website!