Possible to force users to use Views in shared documents?

Copper Contributor

We have a lot of shared documents in Excel on Teams, but have a user training issue with users filtering/sorting the documents without utilizing Views. At month-end that can be a large issue as many users may be in the same file at the same time. I tried locking cells, but unfortunately those locks seem to apply to Views as well, so stopping people from filtering/sorting in the "main" document also stops them from creating a view and filtering there. So, if that's Not an option, is there another option I have to force users to utilize Views to filter/sort shared documents?

0 Replies