Make it as view only while others using the excel file in a shared drive

%3CLINGO-SUB%20id%3D%22lingo-sub-1572252%22%20slang%3D%22en-US%22%3EMake%20it%20as%20view%20only%20while%20others%20using%20the%20excel%20file%20in%20a%20shared%20drive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572252%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20company%20has%20an%20excel%20file%20in%20the%20shared%20drive%20that%20is%20used%20by%20everyone%20in%20the%20team.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20know%20is%20there%20any%20way%20to%20prevent%20the%20user%20(ex.%20make%20it%20as%20view%20only)%20just%20for%20the%20time%20when%20the%20other%20team%20member%20is%20editing%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20forward%20to%20hearing%20from%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1572252%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1572302%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20it%20as%20view%20only%20while%20others%20using%20the%20excel%20file%20in%20a%20shared%20drive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572302%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EOff%20the%20top%20of%20my%20head%20and%20if%20you%20are%20not%20wanting%20the%20Co%20authoring%20experience.%20You%20could%20look%20to%20enable%20require%20check%20out%20on%20the%20SharePoint%20doc%20library.%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%20I%20would%20like%20to%20know%20if%20co%20Authoring%20has%20caused%20you%20issues%20as%20it%20is%20quite%20good%20at%20informing%20when%20someone%20else%20is%20working%20on%20something%20and%20locking%20the%20portion%20of%20what%20is%20being%20worked%20on.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3E%3CBR%20%2F%3EHenry%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1583307%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20it%20as%20view%20only%20while%20others%20using%20the%20excel%20file%20in%20a%20shared%20drive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1583307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F693840%22%20target%3D%22_blank%22%3E%40henryarphillips365%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Henry%2C%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20kind%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20the%20problem%20is%20that%20our%20company%20has%20only%201%20Microsoft%20account%20for%20the%20interns.%20So%20I%20think%20your%20option%201%20and%202%20might%20not%20be%20applicable.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20company%20is%20using%20Google%20Drive%20File%20Stream%20(G%3A)%20to%20save%20and%20edit%20our%20excel%20files.%3C%2FP%3E%3CP%3ECurrently%2C%20pop-up%20appears%20when%20others%20try%20to%20overwrite%2C%20but%20it%20seems%20not%20always%20working%20perfectly%20(we%20still%20have%20overwriting%20issue%20sometimes).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOther%20than%20using%20SharePoint%20or%20co%20Authoring%2C%20is%20there%20any%20other%20options%20such%20as%20using%20VBA%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3ESung%20Jin%20LEE%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello everyone,

 

Our company has an excel file in the shared drive that is used by everyone in the team.

 

I would like to know is there any way to prevent the user (ex. make it as view only) just for the time when the other team member is editing it.

 

Looking forward to hearing from you!

 

Thank you.

2 Replies
Highlighted
Hi,

Off the top of my head and if you are not wanting the Co authoring experience. You could look to enable require check out on the SharePoint doc library.

However I would like to know if co Authoring has caused you issues as it is quite good at informing when someone else is working on something and locking the portion of what is being worked on.

Thanks

Henry
Highlighted

@henryarphillips365 

 

Hi Henry,

Thank you for your kind reply.

 

But the problem is that our company has only 1 Microsoft account for the interns. So I think your option 1 and 2 might not be applicable.

 

Our company is using Google Drive File Stream (G:) to save and edit our excel files.

Currently, pop-up appears when others try to overwrite, but it seems not always working perfectly (we still have overwriting issue sometimes).

 

Other than using SharePoint or co Authoring, is there any other options such as using VBA?

 

Thank you.

 

Regards,

Sung Jin LEE