many people will encounter the read-only restriction of "only viewing but not modifying" when processing Excel tables: after opening xlsx and xls files, they can only view them only read-only, and cannot edit and save changes directly, especially when multiple people collaborate, distribute templates and organize historical files. This article introduces a more efficient method of operating office software, and teaches you how to cancel Excel read-only restrictions in batches, and centrally delete read-only passwords or related password protection settings for files. Follow the steps in the text, in HeSoft Doc Batch Tool Select "Excel Delete Password Protection" in turn, import files, and fill in the corresponding passwords to process multiple forms in batches, reducing the repetitive work of opening and processing one by one, and improving daily office efficiency.
In the daily office, it is very common for Excel tables to be set to "read-only. For example, the quotation form, inventory form and application form sent by colleagues can only be viewed and cannot be modified after opening. Or a batch of historical xlsx and xls files are added with read-only passwords, which takes time to process manually every time. If what you're encountering now is Excel can only view but not modify, Excel cannot be read-only., batch cancel Excel read-only limit this article is prepared for you.
This article will combine HeSoft Doc Batch Tool The actual interface demonstrates how to batch delete the relevant password protection settings in Excel files through office software, and restore the original read-only files to editable state. For users who need to process multiple xlsx and xls tables at once, this batch method is more time-saving than opening Excel one by one and then manually adjusting.
Applicable Scenarios
if you encounter the following situations, the methods in this article are more suitable:
- after opening a batch of Excel files, you will be prompted to enter a password. If you do not enter it, you can only open it "read-only;
- I already know the password corresponding to the file, but there are a large number of files. I want to cancel the read-only limit in batches;
- for template tables, statistical tables, and business ledgers distributed within the enterprise, read-only protection must be removed;
- need to focus on xlsx, xls and other Excel files to avoid duplication of effort.
In particular, what we are talking about here is delete the protection corresponding to a known password not to crack an unknown password. The software interface in the screenshot also clearly indicates that this is not a password cracking, and the software does not have the function of cracking the password.
Effect Preview: Pre and Post Processing
before treatment: when opening the Excel file, the system pops up a password window and prompts "Please enter the password to obtain write permission, or open it as read-only". If you click "Read Only", the file can be viewed, but it cannot be modified and saved normally. This is what many users say "Excel can only view but not modify".
After treatment: after deleting the corresponding password protection in batch through office software, when opening these Excel files, they will no longer be affected by the original read-only restriction, and the files can enter the normal editing state, which is suitable for continuous entry, modification and saving.
Operation steps
step 1: Enter Excel to remove password protection feature
open HeSoft Doc Batch Tool After entering on the left Excel Tools classification. In the function list, you can see" 3. Excel removes password protection"This item, the interface description says" open password and read-only password for batch deletion of Excel files ".
The purpose of this step is to enter the batch function page that deals specifically with Excel password protection. For users who want to cancel the Excel read-only restriction in batches, they can directly enter this entrance without manual operation with Excel software one by one.
Expected Result: Successfully entered the Excel Remove Password Protection feature page.
Step 2: Add Excel files that need to be processed
after entering the function page, you can see "at the top of the page add File"and" import files from a folder"button. You can choose the import method according to the number of files:
- if there are not many files, click "Add File" and manually select the xlsx and xls files to be processed;
- if the files are concentrated in the same directory, click "Import files from folders", which is more suitable for batch processing.
After the import is completed, the file name, path, extension, creation time, modification time and other information will be displayed in the list, which is convenient for you to check whether the import is correct.
The purpose of this step is to add all Excel files that need to be read-only restricted to the task list at one time to avoid repeated operations.
Expected result: All files to be processed appear in the list, and you can see a summary of the number of records.
Step 3: Enter the processing option and fill in the corresponding password information
after clicking "Next" at the bottom of the page, you will enter the "Set Processing Options" page. Several password related areas can be seen here, including:
- file Open Password
- file content read-only password
- workbook Restrictions Password
- worksheet Limit Password
as can be seen from the screenshots, the software specially marked" file content read-only password", and indicate" no need to provide this information". This means that for the scenario of "read-only viewing but not modifying after opening" discussed in this article, the software has already done corresponding processing for this type of read-only password, and users usually do not need to fill in additional content in this item.
If your file itself has other known password protection, such as opening password, workbook restriction password, worksheet restriction password, you need to fill in the correct password in the corresponding area, the software can delete the corresponding protection in batch.
The purpose of this step is to tell the software which types of password protection to remove and to provide the necessary known password information.
Expected result: The relevant password entry is completed, especially the confirmation of the "file content read-only password" does not require additional information.
Step 4: Continue to the next step and complete batch processing
after the processing options are confirmed to be correct, continue to click "Next", set the saving location according to the page flow and start processing. Although the screenshot mainly shows the password setting page, it is clear from the step bar at the top that the subsequent process is "set the saving location" and "start processing" in sequence ".
The purpose of this step is to allow the software to uniformly delete the password protection operation on the imported Excel files, thus canceling the read-only restriction in batches.
Expected result: After the processing is completed, the output new file or processed file can be opened and edited normally, and no longer stays in the status that can only be viewed but not modified.
Frequently Asked Questions or Precautions
1. Is this to crack the Excel password?
It's not. The software interface has been clearly prompted: this is not to crack the password, the software has no function to crack the password. If you don't know the password, you can't directly remove protected content through this process.
2. Is Excel read-only password and open password the same thing?
Not exactly the same. In this scenario, many users perceive that "files can be opened, but can only be viewed read-only and cannot be modified"; However, the processing page of the software divides different types of password protection into file opening password, file content read-only password, workbook restriction password and worksheet restriction password, which are convenient for processing separately.
3. Why use office software for batch processing instead of manual modification?
Because there are many Excel files, it can be time-consuming to open, enter passwords, save as, or modify settings one by one. Like HeSoft Doc Batch Tool This kind of office software, the core value is batch processing of documents, reduce duplication of labor, improve efficiency, especially suitable for administrative, personnel, finance, operations and other high-frequency processing form positions.
What Excel formats are supported?
From the list of files in the screenshot, the sample file is xlsx. Common xlsx and xls in actual office belong to Excel files. It is recommended to check the extension before importing and confirm that the files are not occupied by other programs.
5. What preparations need to be made before processing?
It is recommended to sort out the files to be processed and put them in one folder. At the same time, make sure that you have the legal processing rights of these files, and prepare the known password in advance to avoid processing interruption.
Summary
if you are troubled by problems such as "Excel can only view but not modify", "default read-only after opening" and "restrictions must be removed one by one for a batch of tables", then use HeSoft Doc Batch Tool Will be much more efficient than manual processing. Through the "Excel Delete Password Protection" function, you can centrally import multiple xlsx and xls files, fill in known password information according to the page prompt, and delete relevant protection settings in batches.
For daily office, this batch processing method can significantly reduce the time cost of repeated clicks and repeated opening of files. It is recommended that you organize the Excel files that need to be processed into the same folder first, and then follow the steps in this article to actually operate it once, usually you can more intuitively feel the efficiency improvement brought by office software in batch processing files.