Forum Discussion

Andyf20's avatar
Andyf20
Copper Contributor
Mar 25, 2020

Sheet View in a protected sheet

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 ...
excel
Excel for web
office 365
Mitch621's avatar
Mitch621
Copper Contributor
Nov 03, 2022
I found a resolution that works for me. If I enable "Use AutoFilter" in the 'Protect Sheet' window that pops up when enabling sheet protection, it lets me use my previously created 'Sheet Views'.
StephFox90's avatar
StephFox90
Copper Contributor
Feb 15, 2023

Mitch621 

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.

Resources