Sheet View in a protected sheet

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!