You may need to check with your antivirus provider to learn how to adjust these settings. When saving, Excel whines that it's read only. The file used to have some links but I removed those to see if it would help. I uncheck the read-only attribute. Whether you want other people to edit your excel workbook without permission? Excel will, by default, open documents in Protected View from potentially unsafe locations that includes SharePoint, but doesn't include local or network drives.
Are the file properties set to read-only? Or maybe he already has it open in another window? Click the Repair button to attempt to recover. You'll want to uncheck the box that says Enable Protected View for files located in potentially unsafe locations. 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. The Open Dialog box could create the impression that you are dealing with a Read Only file. When you select this command, a dialog box gives you a choice between attempting to repair the corrupted file or opening the recovered version, extracting data from the file, and placing in a new workbook.
They trust settings are correct. 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. When you open the file, if it is flagged as read only attribute Excel opens it in read only mode and that is fixed. I open a file that's read only. How do I fix this? Best bet would be to do a save as.
If you have no idea about how to , following article would tell you several ways that you can use to restrict other people from changing your workbook. It happens on his and others spreadsheets. Otherwise, you just could open the workbook read only. If so, this is marked as final, as you will see when you hover on that icon. Doesnt seem to be a rhyme or reason for it. In Excel Save As dialog, click Tools and select General Options. My antivirus is causing them to open read-only Some antivirus programs may protect you from potentially unsafe files by opening them read-only.
Click Review tab and Protect Sheet in Changes group. If you do not know the password to open the file for update, the only way I can suggest to get around the problem is cut and paste the the sheets into a new workbook. By using Protected View, you can read a file and see its contents while reducing the risks. But when you save and open this workbook next time, you would find this workbook still recommend you to open it as read only. Click Save button in Save As dialog to save workbook and replace the original one. I actually made sure he wasnt also connected to wireless and he is not he is only hard wired. Then randomly it comes up and says it is in read-only mode.
For information on how to Activate Office, see:. He saves the document as something else. The setting you want is in Excel, not in SharePoint. This is using Excel Version 1808 Build 10730. Changing the attribute once it is already open makes no difference to Excel. Deletes the original document and then renames the newly saved document back to the original name. You can change workbook and save changes this time.
If so, this is marked as final, as you will see when you hover on that icon. This method will guide you to show the Toggle Read Only button in the Quick Access Toolbar easily. . This article will show you the detailed steps to switch to or toggle active workbook between read only mode and editing mode in Excel. To save changes, you just could create a new copy of the workbook and give it a new name, or save workbook in another location. You can check the file properties by right-clicking on the file and choosing Properties. If that is true, then I would take a look at the security options within Excel.
Navigate to each sheet in Workbook you want to keep it read only. But they still have choices to open workbook as read only or not. So even though it could help to set excel workbook read only, it still cannot prevent people from editing. This is also commonly the case with email attachments or files you've downloaded. Then changes cannot be made to the original workbook. Once you have workbook open password or successfully remove open password, you would be able to do anything you want on excel workbook. I use the latest version of Windows and Office.