Current location - Training Enrollment Network - Education and training - What should I do if I forget my password in Excel file?
What should I do if I forget my password in Excel file?
Cracking can be carried out by the following methods, and the steps are as follows:

1, first find the Excel table with the worksheet protection password, and then change the suffix name from the demo operation table. Xlsx to the demo operation table. rar:

2. Open it with a compressed file, and then find the following xl folder:

3. Open the xl folder and find the worksheet folder:

4. Open the worksheet folder and find the sheet 1.xml file:

5. Drag and drop the sheet 1.xml file found in the compressed file. The location can be arbitrary, but it's best to find it conveniently and need to be modified:

6. the way to open the sheet 1.xml file is to open it with notepad, then search for "protection" and select

7. Then drag and drop the modified sheet 1.xml file into the compressed work pool and choose to replace it:

8. Change the file name "demo operation table. Rar" to "demo operation table. Xlsx ",and then double-click to open the Excel table: