Spreadsheet owners are able to edit and remove all protected ranges Adding Editors to a Protected Range (in 7 Steps)īefore jumping directly to removing protection in Google sheets, it’s important to consider if adding editors to that range might be a better option. If you aren’t sure what accounts have this access, you can always contact the spreadsheet owner and ask them to remove the protection. The only potential challenge is that you must be logged into an account which can edit that protected range in order to remove it. Protecting sheets and ranges in Google Sheets is a great way to prevent users from inadvertently making edits to those portions of the spreadsheet.īut sometimes you may find that these protections stop users from making necessary changes to the spreadsheet.Ī spreadsheet with too many protections can become impossible to use, so often it’s necessary to remove some or all protections to continue workingįortunately, removing protections in Google Sheets is quick and easy. Can you hide a sheet in Google Sheets from certain users?.How do I share Google sheets but not allow editing?.How do I protect a spreadsheet in Google Sheets?.Adding Editors to a Protected Range (in 7 Steps).However, the 'mark of the web' (ie right-click the file, Properties > General and tick 'Unblock') had been removed long ago. I wonder if MS has found another way to try and stop macro-enabled files (that have been downloaded / emailed) from running?!Īs an aside, the offending AddIn had been downloaded over the internet. But I know this isn't gonna be the case for every AddIn for everyone.Īs an aside, the offending AddIn had been downloaded over the internet.
If you can identify a specific AddIn (or I guess could be multiple AddIns) and opt not to automatically load it/them when Excel starts then I think this is likely to be a better solution than disabling Protected View (no security risk). In my case, I wasn't really using the offending AddIn so I have left it that it does not load automatically when Excel starts and so I now do not get the message. I went through the list of AddIns (in Excel 365, see: File > Options > Add-ins > Manage > Excel Add-ins > Go) and unticked/unchecked each one individually to find the offending AddIn. In my case, the offending file that causes the message to appear when Excel starts is an AddIn that is being automatically loaded when Excel starts. The problem may be related to an update from Microsoft as it is being reported by users on other sites.
0 kommentar(er)
