When you open a file that has been given this setting, Excel prompts you to open the file in r ead-only mode, unless you want to make edits to it. The File property may be set to ‘Open as Read-only Recommended’Īnother reason might be that the author (or previous user) had set the file to open as ‘ read-only recommended’. Tell-tale signs of a sheet marked as final are a yellow message on the top of the workbook that says ‘Marked as Final: An author has marked this workbook as final to discourage editing’. The author of the sheet (or someone else) might have marked the worksheet as final, and that may be the reason the worksheet is ‘ read-only’. The Sheet may be ‘Marked as Final’Įxcel lets you mark a finished workbook as the ‘ Final draft’ so that others cannot mess with it any further.Īn Excel file that has been ‘Marked as Final’ cannot be edited, so all types of actions on the worksheet are disabled. There might be a multitude of reasons your worksheet or workbook is showing up as ‘ read-only’. To be able to remove read-only from your sheet, it is important to understand why you see it in the first place. Possible Reasons your Sheet is ‘Read-only’ If an antivirus is causing the Workbook to Open as Read-only.If File Properties have been Set to ‘Read-only’.
If the File property was set to ‘Open as Read-only Recommended’.Antivirus may be causing the Workbook to Open as Read-only.File Properties may be set to ‘Read-only’.The File property may be set to ‘Open as Read-only Recommended’.Possible Reasons your Sheet is ‘Read-only’.Re-enabling this setting will not generate a UAC prompt. To re-enable automatic sample submission, just click the slider again. Enable and disable automatic sample submission by toggling the automatic sample submission slider.
While you are safer with this setting enabled, feel free to dismiss the warning and turn it off if you prefer. Once the setting has been disabled, a warning will appear saying that disabling automatic sample submission can leave your computer vulnerable.
Turning off this setting may cause a User Account Control (UAC) prompt to appear, as this change requires administrative rights. To disable automatic sample submission, click on the slider labelled “Automatic sample submission”. Click “Manage settings” under “Virus & threat protection settings”. Then, to open the settings, click “Manage settings” under “Virus & threat protection settings”.
Next, you need to click on “Virus & threat protection” in the left column.
To do so, press the Windows key, then type “Windows Security” and hit enter. If you want to disable automatic sample submission, you first need to open the Windows Security app. Unfortunately, it’s possible for legitimate files with private details to be identified as suspicious incorrectly and then be uploaded for analysis. The idea behind this is that automatically sharing potential threats with the antivirus developer can help identify and then protect you and other users from the threat. Sample submission is where an antivirus program submits a copy of a suspicious file to the developer for further analysis. One of the features that Windows Defender includes is automatic sample submission.