Have you had a headache about password protection for Excel worksheets recently? For example, I received a bunch of forms with passwords, or I set up protection for important data before. Now I need to sort out and analyze them in batches, but I have to enter passwords one by one to open them. This is simply too inefficient! Don't worry, today we'll talk about how to quickly cancel the passwords in these Excel forms in batches, so that the Excel files in your hand can be completely light and accessible at any time!
Why learn to batch remove Excel open password?
most of the time, we or the team will encrypt important files for the safety of data. However, when the files need to be processed centrally or collaborated across departments, repeatedly entering passwords becomes a big trouble, such as financial consolidation of monthly reports and personnel sorting of employees' files. If each file needs to be manually entered, we have to spend a lot of energy and time. Come with me to learn these five skills, can make the encrypted form back to the open state, follow-up whether it is data analysis or format adjustment, can be done in one go, will no longer be bound by the password to their work rhythm!
Batch Cancel Excel Table Open Password Effect Preview
before treatment:
after treatment:
method one: use HeSoft Doc Batch Tool Batch Unencrypt
for Excelrecommended Index:★★★★★
Advantages:
the processing speed is the fastest, supports batch operation of a large number of files, can ensure the integrity of files, and all files are processed locally, does not require uploading files, protects the security and privacy of users, and has a good experience.
Disadvantages:
the software can only be installed in the computer operation use.
Operation steps:
1. Open 【 HeSoft Doc Batch Tool ], find [Excel Delete Password Protection] in [Excel Tools]].
2. Select a method in [Add File] or [Import File from Folder] to add the Excel file that needs to cancel the password, or drag the file directly below to import, and then click Next.
3. Enter the setting interface, enter the opening password of setting Excel form under the file opening password, and click Next after confirmation.
4. After waiting for the processing to be completed, click the red path to open the folder to view the E xcel file with successful password cancellation,
Method 2: Use Excel built-in function to remove the open password
recommended Index:★★★☆ ☆
advantages:
this is the safest and most direct method. It is completely operated within the official function range of Excel and will not cause any damage to the file or loss of data. The operation process is simple and intuitive, and is suitable for users of all Excel versions.
Disadvantages:
you must know the original open password to operate. It is very inefficient to process multiple files in batches. Each file needs to manually repeat the same steps. If the number of files is large, it will be time-consuming.
Operation steps:
1. Open the encrypted Excel file with the original password.
2. Click [File] - [Information] - [Protect Workbook] and select [Encrypt with Password].
3. In the password input box, click OK and the password can be removed after saving.
Method 3: Use VBA macros to batch cancel Excel password protection
recommended Index:★★☆ ☆ ☆
advantages:
it is suitable for batch processing of multiple encrypted files, and can process all Excel files in the entire folder at one time, greatly saving time, and the processing process is automated without manual operation.
Disadvantages:
A certain VBA programming foundation is required. For users who are not familiar with the code, there is a cost of learning. If the code is not written properly, it may also cause file damage, and some security software in the computer will prevent macros from running.
Operation steps:
1. Create a new Excel file and press Alt F11 to open the VBA editor.
2. Insert a new module, paste the password removal code written below, and modify the file path in the code and the values of folderPath and pwd to your actual path and password.
3. Run the macro, automatically open the specified file and remove the password, and then save the processed file.
Method 4: Remove Excel Open Password
by Saverecommended Index:★★★☆ ☆
advantages:
the operation is extremely simple, without any technical knowledge, all Excel versions support this feature, while creating a password-free copy file, the original encrypted file remains as a backup.
Disadvantages:
it is also necessary to manually operate each file, which is inefficient for processing a large number of files, and will create duplicate files to occupy storage space, requiring subsequent manual management of file versions.
Operation steps:
1. Use the password to open the encrypted Excel file and click File-Save.
2. Select the save location and file name, and do not set any password in the save options.
3. After clicking Save, the new file will not be password protected.
Method 5: Use online tools to remove Excel password protection
recommended Index:★★★☆ ☆
advantages:
without installing any software, it is generally a simple user interface. Some services have free operating quotas, suitable for temporary or occasional use, and support various devices across platforms.
Disadvantages:
uploading sensitive files to the server may have serious security risks, and the size of the file is usually limited. The processing speed depends on the network status. Free processing may contain many restrictions.
Operation steps:
1. Open the website with Excel password removal and upload the Excel form to be processed.
2. Enter the original password below, then click Unlock and wait for processing.
3. Save the processed file without password.
Follow-up summary
for ordinary users, good password management habits can be established, important passwords can be recorded, encrypted files can be regularly sorted and updated, and passwords can be removed in time for files that no longer need to be kept confidential. Enterprise users can consider adding or removing passwords in a unified manner to avoid password legacy problems caused by personnel changes. In actual work, if the number of files is small, Excel's built-in function can be used to cancel password protection, but tools can be used to help us maximize efficiency and remove Excel's password protection in batches when we are jealous in batches.