."write passwordFiles with a "+" set will not be accepted unless the password is known.read onlyIt can only be opened with However, if you must write with the protection removed, but you have to write with the protection onPerson in charge has already retiredSometimes, the password is not known because you have lost the note or have lost it.
In such a case, do we have to give up?
No. Follow the steps I am about to explain to writePassword is forcibly removedThe following is a list of the most common types of products that can be used in the market.
In this issue, we will show you how to force the removal of the write password.
For more information on write passwords, please contactHow to set up read-only and password Excel (Excel)article for more information.
- Check to see if a "write password" has been set.
- Check the extension of the Excel book with the "write password".
- Change the extension of the Excel book with "write password" to ".zip".
- Finding data on a sheet
- Restore the ".zip" file extension to its original extension
- Make sure the "write password" is unlocked.
Check to see if a "write password" has been set.
When you try to open Excel, a message like the one below may appear and ask you to enter your password. If you do not know the password, click on "read onlyYou can open it with
This is the "write passwordis set.
Check the extension of the Excel book with the "write password".
If you look at a book with a "write password" set, you will see that it has an extension such as ".xlsx", ".xlsm", or ".xls".
No extensions are shown.in the case ofHow to display file extensions [Windows 11].to view the extension before proceeding to the next step.
this (something or someone close to the speaker (including the speaker), or ideas expressed by the speaker)Change the extension and restore it later.You need to operate it so you don't lose track of it.Remember.Please keep it or write it down somewhere.
Change the extension of the Excel book with "write password" to ".zip".
Next, this(filename) extensionto ".zip".
You will then see a message like the one below and click "Yes".
Then the icon will change as shown in the figure below.
Finding data on a sheet
Open the "xl" folder in the opened folder.
Then a screen like the one shown below will appear. Copy "workbook.xml" by dragging it to the desktop, for example.
The destination location is copied to the desktop in the figure above, but it can be anywhere if you can figure it out.
Next, "right-click" on the file you have just copied and click on the menu that appears, "Edit with NotepadClick on the "□" button.
If you do not see this "Edit in Notepad", you can get the same result by selecting "Notepad" from "Open from Program".
If that is not shown either, you can also open it by opening Notepad first and dragging this file to the Notepad screen.
Then a notepad like this one opens.
From among these, the "fileSharingLook for the part that begins with the word "∗".
Press the "Ctrl" and "F" buttons simultaneously to search.
In the search window that appears, click "fileSharingYou can easily find them by typing in the "□".
."<fileSharingStarting with "/>Select the part ending with "*" and delete it.
Once the "fileSharing" tag has been removed, save and close Notepad.
Save the saved "xml" file toExisting FolderCopy" by dragging or otherwise dragging the file to
When you drag a file, you will see a message like the one below.Copy and replacePlease click on "Click here.
When you have replaced the files, close the zip file folder.
Restore the ".zip" file extension to its original extension
When file replacement is complete, restore the file extension.
.xlsx", ".xlsm", etc.
At this time, be sure to revert to the extension you first checked. If this is not the sameCannot open excel properlyThe following is a list of the most common problems with the "C" in the "C" column.
Make sure the "write password" is unlocked.
Once you have changed the extension, open the Excel file.
The password input screen iswithout having to leaveIf you can open Excel, you have succeeded.
Comment