I need to confirm if you stored the file on your OneDrive. The detailed version of Office, such as Version 1902 Build 11328. You'll want to uncheck the box that says Enable Protected View for files located in potentially unsafe locations. You can lock the file from your end. In the Save As dialog box, you will get Tools option at the bottom right corner of the dialog box. If a spreadsheet is Read Only and cannot be edited, even after checking all settings and ensuring the file is in a location you can save and modify files, saving the file under a new name may remove the Read Only restriction.
It is only when I try and access it from the shared folder from the other computer. You can instead lock it through sharing and permissions located at the bottom of the Get Info box. Click Ok for changes to take effect and click ok final ok to exit from Properties window. You will have to decide for yourself how bad it would be if somebody were to crack your password or save over your file. Click Protect Workbook in the same location and type password to unprotect workbook structure and windows. Tips: Probably your excel file is also protected with open password now besides above edit restrictions. There are several possible reasons for an Excel worksheet to say it is Read Only.
Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don't enter a password and check Read-only recommended. If you select the No option, the file will be opened in editable mode. The reason is you probably don't have permission to read and write. How to Fix Error cannot access read-only document in Excel Step 1 Searching your corrupt Excel file in your local drive. You would need to ask the original file creator to resend it after updating your permissions. The Save As window will appear. To avoid duplicate posts and make your thread easy to read, this thread will be locked.
Then just opening the excel file is a difficult thing, not to say removing read only mode in excel file. Boot to Safe Mode 2. When users who experienced this bug were asked to open the file straight from the network, the file opens as read only, despite being fine for other users. With a single email, a colleague can share a complicated Excel worksheet for you to customize as needed. If the file without the prefix is not opened by anyone at the moment, try to delete the lockfile.
Save the file to some other drive. To help protect your computer, files from these potentially unsafe locations are opened in Protected View. If the file doesn't unlock, you might not have permission to unlock it. Being used by 110,000 elites and 300+ well-known companies. If you do not like without your permission no one can edit or update your Excel file, you can make your Excel file read-only. What else can cause a file to open as read-only? Usually, if you share an Excel spreadsheet with someone, that person is able to freely edit the spreadsheet.
Spreadsheet Settings Excel spreadsheets and workbooks can be protected to prevent changes. Step 4 Save the repaired Excel file to a new location. So, these are the ways to make an Excel file read-only and disable read-only from a read-only Excel file. I recommend doing the following: 1. Because there is a holiday, I don't know exactly when the 16.
In that way, the read-only file can be opened in editable mode by all. I have tried changing the protected view in the trust center with no avail. Then others only can open this Excel workbook in a read-only state. How can I open Excel as an admin all the time by default? Symptoms Excel Document open as Read-Only and Unable to check in the documents are both interrelated issues. If a user has write access to the folder in which the file is saved they could just save down a version of your file, delete the original file, then save a new version with the same name.
Get out of the Excel program, closing the worksheet. Everytime I try to save the file, I get a message that it is a read-only file and that I need to save it with a new file name. I can at least work with that but it was really throwing me for a loop. Document does not checking back in, so user is not able to make any changes. Your Mac will take a long time to boot up as disk repair and maintenance utilities run in the background. If you found this article helpful, and especially if you didn't, please use the feedback controls below to let us know how we can make it better.