Forum Discussion

Mattwlkr's avatar
Mattwlkr
Copper Contributor
Jun 19, 2019
Solved

Excel Filter stumbling block - Teams / SharePoint / Excel Online

We are trying to rollout SharePoint and Teams but have hit a real stumbling block with Excel filters.   A lot of our people work on shared spreadsheets and apply multiple filters. When we come to d...
migration
User Adoption
  • Mattwlkr's avatar
    Mattwlkr
    Jun 24, 2019

    HustleGPTEnd users don't care for the complexities under the hood, If google can sort this out surely MS can.

     

    Imagine being sat in a car and only one person at a time can use a window, I wouldn't buy this, and users aren't going to buy into excel online if they can't individually filter.

akcity's avatar
akcity
Copper Contributor
Oct 21, 2020

Mattwlkrhi there, when I filter Excel using the shared version on Teams or Sharepoint, the filter takes the curor to the bottom of the spreadsheet that takes a few minutes to scroll up to the results. Surely that shouldnt be the case?

Also I cant filter by cell colour. I can 'sort' by cell colour but that isnt the same thing.

Also the sheet doesnt auto populate when putting the same data as the cell above.

Any help please..?

Resources