Click Tools at the bottom of the Save As menu and choose General Options. Under General, find the Read-only Recommended check box and uncheck it. Click OK and finish saving the document.
How do I change a shared Excel file from read only?
Click File -> Save As, select one location where you will save this document. In the Save As dialog, click the drop-down arrow next to the Tools button, and then select General Options. In the General Options dialog, delete the password to modify and uncheck the box next to Read-only recommended, and then click OK.
Why is a shared document read only?
A file is usually showing as read only due to the following reasons: If it is a shared file and the owner restricted the permission for it to be edited. It is a shared file and another user has it opened. A second instance of the Excel (or Word) is running in the background with the same file already opened.
Why is a shared Excel workbook locked for editing?
If you have locked the file yourself, it might be because the file is open on a different device, or the previous instance of the file didn’t close properly. Tip: Sometimes a file may get locked if everyone editing isn’t using a version that supports co-authoring.
How do I permanently turn off read only?
Here’s how:
- On File Explorer, right-click on OneDrive, and then select Properties.
- On the General tab under Attributes, uncheck Read-only, and then click OK.
- There will be a prompt asking if you want to apply changes to all folders, subfolders, and files. Click OK.
How do I change a file from read only to edit?
To change the read-only attribute, follow these steps:
- Right-click the file or folder icon.
- Remove the check mark by the Read Only item in the file’s Properties dialog box. The attributes are found at the bottom of the General tab.
- Click OK.
How do I make an Excel file not read only?
Re: Turn Off Read Only
- Select No when prompted to open the Excel worksheet as read-only.
- Choose File, followed by Save As and Browse.
- Click Tools at the bottom of the Save As menu and choose General Options.
- Under General, find the Read-only Recommended check box and uncheck it.
- Click OK.
Why is my Excel file read only?
Excel spreadsheets may be Read Only due to their location. If the spreadsheet is on a network folder and you do not have appropriate network permissions to make make changes in the folder, the spreadsheet is Read Only. Spreadsheets sent as email attachments and previewed within the email program are also Read Only.
How do I turn off read only?
How do I unlock a shared Excel spreadsheet?
Right-click “My Computer,” select “Manage,” and navigate the “Shared Folders” tab to find and disconnect the open file. Keep in mind that only a network administrator with administrative privileges to the server can unlock the Excel file in this manner.
How do I turn off read only in Excel?
Why can’t I turn off read only?
If your folder keeps reverting to read-only it could be due to a recent Windows 10 upgrade. Many users have reported that when upgrading their system to Windows 10, they encountered this error. Read-only is a file/folder attribute that lets only a specific group of users read or edit the files or folder.
How do I delete a shared workbook that is read only?
Have all the users… by boxfiddler Moderator · 14 years ago In reply to Shared Workbook giving “r right-click on the unopened file and select properties. If Read-Only in the lower portion of the dialogue box is even partially selected, have them clear it.
Do remote users keep the shared workbook open?
None of the remote users keep the shared file open for long periods of time in case there’s a blip in the vpn and they get disconnected (thus not saving their work to the shared file). Thanks for the thought, though… Have all the users… by boxfiddler Moderator · 14 years ago In reply to Shared Workbook giving “r
Is it possible to share a workbook?
The shared workbook “feature” is notoriously unreliable, hence the odd behaviour. I always recommend not to use that option. Are you saying there are people using different versions of Excel working with that file? That is even a bigger reason not to share, mixed Office versions cause extra trouble. of XLSX.
Why does my file open as read-only?
You may find that when you are opening files, they open as read-only. In some cases, this is for added security, such as when you are opening files from the internet, and other times, it can be due to a setting that can be changed. Here are some scenarios where a file opens read-only and some steps you can take to change that.
