Jul 29 2021 08:36 AM
I have a workbook set up on teams that users can access and gain Sales information from using different filters but can edit the data as its locked. Is it possible for users to be able to use the same workbook but they cant see what each other is doing and their changes they make to get information are just seen by them.
At the moment if 2 users are dialled in when they change filters those changes appear in the other persons screen thus hindering them on getting the info they want and they have to wait until the other person finishes.
Is it possible to share the file but people can use it independently at the same time?
Best regards, Chris
Aug 14 2021 12:18 AM
SolutionAug 14 2021 01:49 AM
Aug 14 2021 02:02 AM
I don't know if the company you work for has to follow SOX compliance, if it is required, having a read only source file that everyone can query into would comply with SOX.
Aug 14 2021 04:25 AM
If the goal is to sort and filter working in such views independently when Sheet Views in Excel - Office Support (microsoft.com) could work.
Aug 14 2021 12:18 AM
Solution