Forum Discussion
Excel Sheet View not working
- JessicaB1Jul 21, 2021Copper Contributor
I have the same issue. The desktop app worked great before. But in the last few months it stopped working. Now, when I activate a new view, then sort or filter, the changes show up for others in the document.
I see a note on this page https://support.microsoft.com/en-us/office/sheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6#ID0EBADAAA=Desktop that says:
When you use Sheet View in desktop Excel and save your document, any sorts and filters you have made will appear in the Default view for all users. Sheet Views are not affected.
But when the common autosave feature is turned on, which we would need it to be, that means that the filters and sorts used in sheet view will appear for all users still in Default?
Hoping to get some clarity on this soon!
- Excel1265Jun 22, 2022Copper ContributorI'm having the same issue, very frustrating. I can see new sheet view works as it should in the browser version of Excel, but not in the desktop app which is far superior.
What's the point in allowing you to use the desktop app for a shared spreadsheet if you can't use the sheet view properly?