SOLVED

Sharing workbooks on Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-2595169%22%20slang%3D%22en-US%22%3ESharing%20workbooks%20on%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595169%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20set%20up%20on%20teams%20that%20users%20can%20access%20and%20gain%20Sales%20information%20from%20using%20different%20filters%20but%20can%20edit%20the%20data%20as%20its%20locked.%20Is%20it%20possible%20for%20users%20to%20be%20able%20to%20use%20the%20same%20workbook%20but%20they%20cant%20see%20what%20each%20other%20is%20doing%20and%20their%20changes%20they%20make%20to%20get%20information%20are%20just%20seen%20by%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20the%20moment%20if%202%20users%20are%20dialled%20in%20when%20they%20change%20filters%20those%20changes%20appear%20in%20the%20other%20persons%20screen%20thus%20hindering%20them%20on%20getting%20the%20info%20they%20want%20and%20they%20have%20to%20wait%20until%20the%20other%20person%20finishes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20share%20the%20file%20but%20people%20can%20use%20it%20independently%20at%20the%20same%20time%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%20Chris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2595169%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2647861%22%20slang%3D%22en-US%22%3ERe%3A%20Sharing%20workbooks%20on%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2647861%22%20slang%3D%22en-US%22%3Eput%20the%20workbook%20in%20a%20shared%20directory%20and%20have%20the%20users%20pull%20the%20data%20using%20power%20query%20into%20their%20own%20workbooks%20and%20manipulate%20the%20data%20in%20their%20own%20workbooks.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2647949%22%20slang%3D%22en-US%22%3ERe%3A%20Sharing%20workbooks%20on%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2647949%22%20slang%3D%22en-US%22%3EAgree%20with%20Yea_So.%20Shared%20directories%20like%20one%20drive%20and%20others%20work%20well%20here%20-%20they%20also%20have%20a%20button%20that%20normally%20allows%20you%20to%20open%20in%20your%20desktop%20app%20(%20so%20as%20soon%20as%20they%20go%20of%20the%20%22Cloud%20Version%22%20it%20will%20ask%20if%20the%20want%20others%20to%20see%20your%20filter%20or%20not.%3C%2FLINGO-BODY%3E
New Contributor

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

6 Replies
best response confirmed by allyreckerman (Microsoft)
Solution
put the workbook in a shared directory and have the users pull the data using power query into their own workbooks and manipulate the data in their own workbooks.
Agree with Yea_So. Shared directories like one drive and others work well here - they also have a button that normally allows you to open in your desktop app ( so as soon as they go of the "Cloud Version" it will ask if the want others to see your filter or not.

@eoliams 

 

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.

@jaffers2906 

If the goal is to sort and filter working in such views independently when Sheet Views in Excel - Office Support (microsoft.com) could work. 

@Yea_So

 

Thank you

Thanks to everyone that's really helpful