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

Highlighted

@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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies