Forum Discussion

Copper Contributor

Jul 25, 2022

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 ...

excel

office 365

Excel1265

Copper Contributor

Jul 27, 2022

Were you able to reproduce this?

cool2021

Iron Contributor

Jul 27, 2022

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.

Excel1265
Copper Contributor
Jul 27, 2022
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.
- cool2021
  Iron Contributor
  Jul 27, 2022
  Excel1265 , try reading this blog discussion about sheet view and Excel 365:
  https://techcommunity.microsoft.com/t5/excel/sheet-view-in-desktop-app/m-p/2110957
  - Excel1265
    Copper Contributor
    Aug 03, 2022
    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.