Forum Discussion
SheetView not working excel on line
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.
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.