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
Matt_Newman's avatar
Matt_Newman
Copper Contributor
May 12, 2021
I've got exactly the same issue Lisa, O365 on a W7 platform (16.0.12527.21824, W7 Enterprise SP1 x64) and Sheet View isn't even present in the View tab of Excel. It's driving me nuts.
  • 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