Sheet View in a protected sheet

Occasional Visitor

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?

4 Replies

To add to this, A new Temporary View can be created, but saved views can not be selected.

I am also finding this an annoyance.

No solution after 18 months?

Same issue here for some Temporary Views already created. 

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'.