I use Excel 365 for work and we use Sharepoint for shared spreadsheets. It's good practice to use a custom view for any filters or sorts you want to apply to avoid it affecting other users, and this works fine on the browser version, however it doesn't in the desktop app which I much prefer. If you use a sheet view on the desktop app then apply a custom sort and/or a filter then this will also apply to the default view, which obviously defeats the purpose of sheet view.

Excel1265 I posted on another Microsoft support forum and was given the advice to file a support ticket via our administration. A Microsoft employee contacted me this morning to view the issue firsthand. Not holding my breath, but perhaps if enough of us submit tickets we can get this on someone's radar to fix. I will let you know if I get any worthwhile response back. Sheet Views - Filtering & Sorting Functions Broken - Microsoft Community

In Excel 365 you can use an Excel file that's saved in Sharepoint or One Drive either through the browser or via the Desktop App, that's how I'm using it in this scenario. I can get Sheet view to work, but whenever I apply filters or sorts it will also apply this to the default view, which it shouldn't. That's my problem.Any help would be appreciated, thanks.

Excel1265 Hi - I know this is old, but we are having the same issues. Any luck finding a solution?Each employee has their own sheet view, but anytime someone filters in their own view, it impacts ALL users. Sorting, hiding columns, and freezing panes are all actions that impact all workers, even though they are working in their own established sheet view. We are accessing it via a sharepoint desktop folder. Windows 10.

LaurLaura okay. So leave your data in Excel. Each user can still use Power Query or SQL or Data Import features in their Excel to access source file and not alter for other users as they filter..sort..analyze.

This is a common issue for many users and Microsoft needs to fix it. We just switched back over to Microsoft from Google docs, and now everyone is ready to switch back.

Excel 365 sheet view not working in the desktop app

WillHeighington
Copper Contributor
Jul 26, 2023
Excel1265 Have you ensured that you are not already in a temporary view? Under the view ribbon, on the far left, if your view is not default, click exit and you should be able to create another temp view.
Willjoe2442
Brass Contributor
Jul 28, 2022
ry starting Excel without add-ins to see if the problem goes away. Do one of the following: If you are running Windows 10, choose Start > All apps > Windows System > Run > type Excel /safe in the Run box, then click OK.

Regards,
Will
- Excel1265
  Copper Contributor
  Aug 03, 2022
  Willjoe2442 I tried this but it didn't work, my changes in sheet view, in this case sorting two columns, applied to the default view as well.
cool2021
Iron Contributor
Jul 25, 2022
When you have Excel 365 open.....go 'File'---'Save As' at the top right hand menu and this will allow you to download and open your document id Desktop App.
- Excel1265
  Copper Contributor
  Jul 26, 2022
  Thanks for the reply. I have had no problem accessing the desktop app, the problem is sheet view doesn't work properly on the app.
  - cool2021
    Iron Contributor
    Jul 26, 2022
    Excel1265 , SheetView is Cloud-based....meaning, documents you work on are being shared and may be accessed by others. So this feature will not work on Desktop App because Desktop App assumes your are working on a local (version of spreadsheet only on your PC, not in Cloud).

Forum Discussion

Excel 365 sheet view not working in the desktop app

Resources