Forum Discussion
Excel 365 sheet view not working in the desktop app
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).
Not exactly. These days Desktop App assumes we are working with files kept on OneDrive/SharePoint (or other shared resources). For the files kept on SharePoint sheet view in Desktop app shall work.
As for the initial question - will try to reproduce.
- Were you able to reproduce this?
Excel1265 no, because I really only use VBA to access files and work with in Desktop App...whether from OneDrive or somewhere else. How are you accessing the file from Desktop App: are you trying to open, connect to or import? Instead of using the 'File'--'Open' option to get the file, try going to the 'Data'--'Get Data' menu at the top of Excel which will open a unique version of the file only on Desktop App and not reflect any changes re: Sheet view, filtering etc. This should work if file is .csv, .txt and Excel file versions. Other than this, I have no idea.
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.
