- #HOW TO UNLOCK EXCEL FILE LOCKED FOR EDITING BY ME PASSWORD#
- #HOW TO UNLOCK EXCEL FILE LOCKED FOR EDITING BY ME WINDOWS#
Case 4: Worksheet and Workbook structure is locked and read only Click OK to save excel file to replace the read-only one. Click File > Save As, and click Save button in pop-up Save As dialog.Ģ. It seems you cannot do any changes on it, but you can save the read-only excel file as another one to remove modify password.
#HOW TO UNLOCK EXCEL FILE LOCKED FOR EDITING BY ME PASSWORD#
While you are trying to open excel file that is restricted modify, and a password is required for write access, instead of entering password, please just click “ Read Only” button to open excel file as read only. Case 3: Excel file is restricted modify and read only It means you have disabled read-only in Excel file. From then on, the copied Excel file would be not read-only and could be used instead of original one. Back to Save As dialog and click “ Save” button to make a copy of original excel file. Uncheck “ Read-only recommended“ and click OK.ģ. Then click “ Tools > General Options” in Save As dialog.Ģ. Now if you make any changes on the excel file, and want to save, there would be a message that prompts you again to save a copy of the file and rename it.ġ. When a dialog appears and shows three options for you to choose after you double click the read-only excel file, just click “Yes” and you could open excel file in read-only mode. Case 2: Excel file becomes read-only recommended by “Save As” Now you have been able to edit excel file and make any changes to worksheet or workbook. To remove read only from excel file, you just need to click on “ Edit Anyway” button on message bar. While you open an excel file that has been marked as final, you would see a message bar at the top of sheet window.
#HOW TO UNLOCK EXCEL FILE LOCKED FOR EDITING BY ME WINDOWS#
The very fact I can rename the file while it is supposedly 'in use' tells me that something is getting quite confused here.Īny ideas what I can do other than reboot the server? The other things i have tried is stop/start the WIndows Search service and rebuild the index. If the file has a different name, it works fine. As soon as I rename the file back to the original name, the same error occurs. I was running out of ideas so decided to copy the file, delete the original and then rename the copied file to the same name as the original. However, there is NO sign of the file being opened. Normally I would just log on the file server, open computer management > Shared folders > Open Files and close the open file. The user stated left the company a long time ago, but in my experience it is not that unusual for Excel/Word to report the incorrect user. A user is reporting that they cannot open an Excel file (on a shared folder) as it is locked for editing by another user.