Temporary/saved views not working correctly in Excel 365 Web version

Jen T

New Member
Joined
Dec 10, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
  2. Web
My team has a Excel file (~2MB) and does concurrent editing, only about 5-10 users at a time. Worksheet protection is on, with some columns editable, others are not. Everyone has been instructed to stay in the web version of Excel. Some users have created their own views, and saved them. The problem is that sometimes the views don't work. The user will select their view name from the dropdown. Excel shows that name as the now current view (instead of Default), but the data does not change, and after a few seconds, Excel goes back to showing "Default" as the view name. This does not happen all the time, sometimes the view can be used successfully, sometimes not.

I thought maybe someone was going into the Desktop version, and that was causing a problem for the users in the web version, but I tested that and it did have any impact. I'm at a loss as to what else could be happening. Has anyone else seen this, or have any ideas I could test?
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,122,354
Messages
5,595,674
Members
414,008
Latest member
zcaa0g

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top