Sheet View not working in Excel online/Excel for the web/Excel web version even when hosted in OneDrive

I have a question regarding Excel for the web, aka Excel online and Excel web.

My team accesses Excel online via OneDrive. We would like to use sheet view in order to not see each other's sorting when we are all editing a sheet at once. However, we find that we are seeing each other's sorting even with sheet views turned on.

I have tried to find the answer by going though MS support articles, chatting with representatives, and using the Q&A forum where the AI answers the question. I have a screen recording demonstrating the problem.

Any insight would be greatly appreciated.

Some information that may be useful:

• This issue happens regardless of how many team members are simultaneously editing the sheet. It's as though sheet view is not turned on at all
• We have tried using sheet view when both members are using a different sheet view, as well as when only one member is using sheet view and the other is using the Default view. The result is the same - we both only see the default view, as though sheet view is not turned on at all
• Sheet view is not grayed out in the toolbar. It appears fully active and functions exactly as described in the page linked above, with the exception that there is no effect on how spreadsheets appear to us (we all continue to see the Default view, and each other's sorting, when sheet view is turned on)

Our team setup meets all of the conditions described in the AI response to my Q&A post, which I will paste here:

If everyone is:

- Working in the same workbook stored on OneDrive/SharePoint, and

- Actually in a non-default Sheet View (eye icon visible, view selected from the Sheet View menu), and

- Using sorts/filters (not global hide/unhide in default view),

then each person’s Sheet View should prevent them from seeing each other’s sorts and filters in Excel for the web.

If the behavior still matches “everyone only sees the default view,” the next checks are:

- Confirm the file is opened from OneDrive/SharePoint (not a downloaded local copy).

- Confirm each person has explicitly selected a named Sheet View (or the temporary view) from View > Sheet View, and sees the eye icon on the sheet tab.

- Ensure sorts/filters are applied after entering the Sheet View, not before.