Forum Discussion

LisaOwczarek's avatar
LisaOwczarek
Copper Contributor
Apr 06, 2021

Excel Sheet View not working

Hello,  When I open a workbook that is shared in Teams in Excel Desktop app and filter the data in Sheet view, other users, that have access to that file, can see my changes even though I clicked th...
excel
Excel for web
office 365
JessicaB1's avatar
JessicaB1
Copper Contributor
Jul 21, 2021

Matt_Newman @lisaowczarek

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!

Excel1265's avatar
Excel1265
Copper Contributor
Jun 22, 2022
I'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?

Resources