Home

Worksheets no longer remain exclusive if user steps away and PC goes to sleep

%3CLINGO-SUB%20id%3D%22lingo-sub-688901%22%20slang%3D%22en-US%22%3EWorksheets%20no%20longer%20remain%20exclusive%20if%20user%20steps%20away%20and%20PC%20goes%20to%20sleep%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-688901%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20document%20on%20a%20shared%20file%20that%20when%20%22user%201%22%20opens%20it%2C%20no%20one%20else%20can.%26nbsp%3B%20However%20it%20appears%20that%20for%20some%20users%20this%20%22exclusiveness%22%20goes%20away%20after%20a%20period%20of%20time%20and%20someone%20else%20can%20open%20the%20worksheet%20unaware%20that%20user%201%20still%20has%20it%20open%20on%20their%20desktop.%26nbsp%3B%20This%20is%20quite%20frustrating%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-688901%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-689087%22%20slang%3D%22en-US%22%3ERe%3A%20Worksheets%20no%20longer%20remain%20exclusive%20if%20user%20steps%20away%20and%20PC%20goes%20to%20sleep%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-689087%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359269%22%20target%3D%22_blank%22%3E%40wfantozzi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWill%20need%20to%20clarify%20a%20couple%20of%20things.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhere%20is%20the%20file%20stored%3F%20E.g.%20is%20it%20on%20a%20file%20drive%20(x%3A)%20or%20is%20it%20in%20OneDrive%2FSharePoint%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20also%20curious%20if%20you%20want%20co-authoring%20access%20or%20if%20the%201%20user%20at%20a%20time%20approach%20is%20the%20desired%20method.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suspect%20when%20the%20laptop%20goes%20to%20sleep%2C%20the%20connection%20to%20the%20file%20is%20severed%20and%20the%20file%20is%20eventually%20unlocked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-690600%22%20slang%3D%22en-US%22%3ERe%3A%20Worksheets%20no%20longer%20remain%20exclusive%20if%20user%20steps%20away%20and%20PC%20goes%20to%20sleep%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-690600%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20file%20is%20on%20a%20file%20shared%20drive%3B%20We%20have%20been%20using%20the%20one%20user%20at%20a%20time%20approach.%26nbsp%3B%20I%20am%20a%20bit%20uncomfortable%20with%20the%20coauthoring%20approach%20as%20I%20am%20unfamiliar%20with%20how%20it%20works.%26nbsp%3B%20We%20are%20using%20this%20file%20to%20assign%20blend%20id%20codes%20for%20our%20wine%20lots%20so%20it%20is%20important%20not%20to%20have%20duplicates.%3C%2FP%3E%3C%2FLINGO-BODY%3E
wfantozzi
New Contributor

We have a document on a shared file that when "user 1" opens it, no one else can.  However it appears that for some users this "exclusiveness" goes away after a period of time and someone else can open the worksheet unaware that user 1 still has it open on their desktop.  This is quite frustrating

2 Replies

Hi @wfantozzi 

 

Will need to clarify a couple of things.

 

Where is the file stored? E.g. is it on a file drive (x:) or is it in OneDrive/SharePoint?

 

I am also curious if you want co-authoring access or if the 1 user at a time approach is the desired method.

 

I suspect when the laptop goes to sleep, the connection to the file is severed and the file is eventually unlocked.

 

Cheers

Damien

@Damien Rosario 

The file is on a file shared drive; We have been using the one user at a time approach.  I am a bit uncomfortable with the coauthoring approach as I am unfamiliar with how it works.  We are using this file to assign blend id codes for our wine lots so it is important not to have duplicates.

Related Conversations