SheetView not working excel on line

[AlanRivera]

Im looking for help since we (like 30 people) are working with an excel book located on onedrive. We were using sheet views so every one could filter the spreadsheet without messing with the others and it woked perfectly. But in some point something changed and every time we set a sheet view and apply a filter it will affect the default view. We tried to delete the views and setting new ones, bu the behavior is the same.

Does anyboy nows about this issue or a solution for it?

Thanks

[#2 · Accepted solution]

@AlanRivera 

One possible solution is to check the settings of your workbook and make sure that the option “Allow changes by more than one user at the same time” is enabled. This option can be found under the Review tab, in the Changes group, by clicking on Share Workbook. This will allow you to use sheet views without affecting the default view or other users’ views.

Another possible solution is to use the Filter command instead of the Sort & Filter command in the Data tab. The Filter command will apply a filter only to your sheet view, while the Sort & Filter command will apply a filter to the entire workbook.

I hope this helps.