Jul 25 2022 03:15 AM
Jul 25 2022 03:15 AM
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.
Jul 25 2022 07:50 AM
Jul 26 2022 01:59 AM
Jul 26 2022 04:20 AM
@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).
Jul 26 2022 04:42 AM
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.
Jul 26 2022 05:32 AM
@Sergei Baklan , yes. But the Sheet View will still not work. Even though Desktop App does integrate well with OneDrive.
Jul 26 2022 10:01 AM
Jul 26 2022 05:50 PM
@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.
Jul 27 2022 01:42 AM
It depends on settings. You may change them and clicking on file name in SharePoint it will be opened in desktop app.
Jul 27 2022 04:23 AM
@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.
Jul 27 2022 07:20 AM
@cool2021 I'm accessing via the Sharepoint folder, I click on the menu to select open in Desktop App. I don't want to use Data and Transform as I need to use the shared spreadsheet. It's one we all use.
Jul 27 2022 02:17 PM
@Excel1265 , try reading this blog discussion about sheet view and Excel 365:
Jul 27 2022 11:59 PM
Aug 03 2022 07:35 AM
@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.
Aug 03 2022 07:37 AM
@cool2021 Thanks, but the problem they are having doesn't apply to me. They are unable to access sheet view at all, whereas I can access it but it doesn't work as it should.
Aug 05 2022 03:48 AM
@Excel1265 , could be a version of Windows based on this post from last year. Maybe you need to Windows 10? https://community.spiceworks.com/topic/2290622-excel-sheet-view-not-showing-up-for-some-users