Mar 25 2020 03:19 AM
When I protect a worksheet that is shared with users over Office365, the custom view feature no longer works. The views previously created are still listed and can be selected, but a message appears saying "This sheet is protected" and the sheet view does not load.
Is there a solution?
Nov 20 2020 07:29 AM
To add to this, A new Temporary View can be created, but saved views can not be selected.
Mar 25 2022 05:36 AM
May 09 2022 12:45 PM - edited May 09 2022 12:55 PM
Same issue here for some Temporary Views already created.
Nov 03 2022 02:01 PM
Feb 15 2023 07:42 AM
I was wondering if there are any other solutions to this issue? As ticking 'Use Autofilter' does not fix my issue in Sharepoint.
I have a spreadsheet on Sharepoint that currently has 4 different custom views that different people use. I have the sheet protected as there are formulas that I don't want amending or deleting by users of the spreadsheet - in the protection settings 'Use Autofilter' is selected, along with 'Sort'.
In Sharepoint, users cannot access the custom sheet views when the document is protected (the same error message stated in the original post appears and it goes back to default view), as soon as you unprotect the document it allows you to select them.
In the Desktop App it allows users to use the custom sheet views both when the sheet is protected and when it isn't, which is strange!
Is there any way I can get it to work in Sharepoint as many of the people using the spreadsheet do tend to have it open in Sharepoint rather than the desktop app.
Many thanks,
Steph.
May 24 2023 12:55 PM
Jul 09 2023 06:18 AM
@Andyf20 I'm also having lots of issues with this. Sheet views online appear to be very temperamental. One thing I've found has often worked is to lock all cells (which is the default anyway), then unlock cells in the table you want to be editable (in desktop version format options). Enabling Autofilter in protect mode then appears to work. I've had this working for long periods, however I've found that this is not always consistent. Sometimes I'll get the same error message e.g. "Some cells in this sheet are protected" without me having changed anything. It's almost like it gets corrupted at some point. Sometimes it can be fixed by making the full table an unlocked range within excel online, but that is not ideal as there may be items you don't want users to be able to edit. Often the only fix is to recreate the table, which can take significant work - and is not always guaranteed that will fix the problem either. The sheet view option is so useful, but there are clear glitches which mean the behaviour is not consistent. Microsoft need to fix this. If anyone has any further advice it would be welcome!