Forum Discussion

Excel1265's avatar
Excel1265
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
LaurLaura's avatar
LaurLaura
Copper Contributor
Dec 07, 2022

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. 

 

https://answers.microsoft.com/en-us/msoffice/forum/all/sheet-views-filtering-sorting-functions-broken/08dcdea8-3d41-4cff-865d-8c5e52d3d286?messageId=df9a1a0a-216e-4eb5-9738-15dbcdc9885a 

cool2021's avatar
cool2021
Iron Contributor
Dec 07, 2022

LaurLaura I am not sure the nature of your data. However, as a rule of thumb, if you have a raw datafile shared amongst several people in the Cloud, it should never be in a spreadsheet. Instead, it should be in a raw format like a .csv or .txt datafile stored either in OneDrive or on a Cloud server. Then, whether it be from Excel Desktop OR Excel 365, any user can access the source, shared datafile and get it into their Excel in several ways before doing their filtering and sorting: 1) PowerQuery, 2) SQL 3) Import.

 

Raw data -- should never be stored in OneDrive in an Excel file format to begin with.

  • cool2021's avatar
    cool2021
    Iron Contributor
    Feb 06, 2023
    What about if each user has their OneDrive auto synced to changes made on local version automatically get made on Cloud version in OneDrive? That's how mine works. Auto sync updates Desktop to OneDrive.
  • cool2021's avatar
    cool2021
    Iron Contributor
    Feb 02, 2023

    ExcelUser01 Okay. Fair enough. Guess it depends on application. Good Luck.

  • ExcelUser01's avatar
    ExcelUser01
    Copper Contributor
    Feb 02, 2023
    This does not work for a collaborative work product which requires real-time changes and review of updates by multiple users.

    I could understand working like this in a git environment, where the utilities available would give advanced options to push / pull and review changes between multiple versions, with one main version.

    Not applicable for how users expect Excel in the cloud to function. Google sheets handles this type of thing just fine, by comparison.
  • ExcelUser01's avatar
    ExcelUser01
    Copper Contributor
    Feb 02, 2023
    What are you talking about? When multiple users are editing a live data table (such as a project tracking sheet) in the cloud, your method doesn't work.
  • cool2021's avatar
    cool2021
    Iron Contributor
    Jan 06, 2023

    MLSA2022 , no problem. It's based on my experience: use Excel (either Desktop or Web) to connect to data in the Cloud, and, then, each individual user can do whatever they want on their data without altering the source file.

  • MLSA2022's avatar
    MLSA2022
    Copper Contributor
    Jan 04, 2023
    Thanks for taking the time into talking to them. Sadly we wanted to use that filtering too
  • cool2021's avatar
    cool2021
    Iron Contributor
    Dec 07, 2022

    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.

  • LaurLaura's avatar
    LaurLaura
    Copper Contributor
    Dec 07, 2022
    It isn't raw data and should be in an excel format based on what it is. Thanks.

Resources