Forum Discussion
Excel 365 sheet view not working in the desktop app
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 ...
SergeiBaklan , yes. But the Sheet View will still not work. Even though Desktop App does integrate well with OneDrive.
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.
Any help would be appreciated, thanks.
Excel1265 not sure then. All I know is that when you open an Excel file from OneDrive or SharePoint, the default is in web view. And you have to save a copy or download to Desktop version before working with it. Sorry.
It depends on settings. You may change them and clicking on file name in SharePoint it will be opened in desktop app.
