Is this possible?

%3CLINGO-SUB%20id%3D%22lingo-sub-2089224%22%20slang%3D%22en-US%22%3EIs%20this%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089224%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20question%20stems%20from%20a%20project%20I%20am%20tackling%20to%20develop%20an%20IT%20solution%20for%20arranging%20a%20large%2C%20unorganized%2C%20growing%20database%20to%20be%20queried%20by%20many%20users.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20upload%20the%20excel%20file%20to%20OneDrive%20and%20manage%20and%20share%20a%20single%20master%20copy%20of%20it%20with%20around%20100%20people.%20This%20is%20the%20issue.%20When%20sharing%20the%20excel%20file%20online%20via%20OneDrive%2C%20I%20cannot%20seem%20to%20find%20a%20way%20to%20disable%20collaboration.%20When%20multiple%20users%20attempt%20to%20query%20the%20worksheet%2C%20they%20are%20out%20of%20luck%20because%20only%20one%20can%20at%20a%20time%20due%20to%20Excel's%20collaboration%20feature.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20know%2C%20like%20I%20said%2C%20if%20this%20can%20be%20disabled%20while%20sharing%20a%20single%20workbook.%20In%20essence%2C%20is%20there%20a%20way%20for%20this%20single%20document%20to%20appear%20to%20and%20work%20for%20each%20user%20as%20if%20that%20user%20were%20the%20only%20user%20accessing%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2089224%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2089719%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20this%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089719%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F939787%22%20target%3D%22_blank%22%3E%40mddphd%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20my%20knowledge%20nope%2C%20co-authoring%20mechanism%20assumes%20all%20users%20who%20have%20R%2FW%20access%20to%20the%20file%20could%20edit%20it%20simultaneously.%20For%20SharePoint%20library%20you%20may%20use%20check-in%2Fcheck-out%2C%20with%20it%20only%20one%20user%20at%20a%20time%20may%20edit%20the%20file%2C%20all%20others%20will%20have%20it%20as%20R%2FO%20file%20at%20that%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

This question stems from a project I am tackling to develop an IT solution for arranging a large, unorganized, growing database to be queried by many users.

 

I would like to upload the excel file to OneDrive and manage and share a single master copy of it with around 100 people. This is the issue. When sharing the excel file online via OneDrive, I cannot seem to find a way to disable collaboration. When multiple users attempt to query the worksheet, they are out of luck because only one can at a time due to Excel's collaboration feature.

 

I want to know, like I said, if this can be disabled while sharing a single workbook. In essence, is there a way for this single document to appear to and work for each user as if that user were the only user accessing it?

1 Reply

@mddphd 

To my knowledge nope, co-authoring mechanism assumes all users who have R/W access to the file could edit it simultaneously. For SharePoint library you may use check-in/check-out, with it only one user at a time may edit the file, all others will have it as R/O file at that time.