Forum Discussion
ryanmorgan
Dec 15, 2021Copper Contributor
Sheet View unexpected behaviour
I administer several Excel 365 workbooks that are worked on by numerous colleagues. Each workbook contains only 1 sheet with 1 data table. I have created Sheet Views so colleagues can view differen...
KripaluJes
Jul 13, 2022Copper Contributor
I am having this issue too! It seems that if you use a custom Sheet View and do not exit the Sheet View before Closing the File, the Default is overridden by the settings from the custom view that was in place when the document was closed. The solution is to ask everyone to exit their views before closing, but realistically that is not always going to happen. I don't know a way to prevent it. Have you had any luck with a solution? I cannot find anything online about it but it seems like a bug to me.