Forum Discussion
Custom Sheet View is not working in Office 365
Hi, Just looking for a bit of help. I might know the answer but I just need someone to confirm the reason why Sheet View is not working. My excel file is shared with nearly 40 people in my orga...
I think you will have to live with the current limitation that dictates you can only have one table (or filter) per worksheet if you want to use custom sheet views.
This is a buggy, half-baked feature released by MS - ridiculous. If you set up a sheet view and then exit it (go to default view), Excel still thinks there is a filter enabled. This prevents the user from moving around columns or doing anything that is prohibited in filtered views. There is no way to clear the filter from the "Sort & Filter" menu - "Clear" shows up as an option, but when the user clicks it, it does not clear the filter. Bottom line, Excel thinks there is a filter set when there is nothing being filtered. The only workaround is to exit and open Excel again. Crazy this is such a major bug so long after release! Please address this Microsoft!