Home

File locked for editing - always same person

%3CLINGO-SUB%20id%3D%22lingo-sub-307976%22%20slang%3D%22en-US%22%3EFile%20locked%20for%20editing%20-%20always%20same%20person%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307976%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20workbook%20that%20is%20worked%20in%20by%20multiple%20people.%20When%20the%20file%20is%20opened%20by%20someone%20else%20and%20you%20try%20opening%20it%2C%20it%20prevents%20you%20from%20opening%20it%20in%20edit%20mode%20-%20just%20like%20it%20should.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20we%20are%20having%20is%20that%20it%20always%20says%20that%20the%20file%20is%20opened%20by%20this%20one%20person%2C%20even%20if%20this%20is%20not%20the%20case.%20This%20makes%20for%20a%20lot%20of%20frustration%20(%22who%20has%20the%20file%20opened%3F%22)%20since%20we%20don't%20know%20who%20has%20it.%20The%20same%20can%20be%20said%20for%20when%20someone%20forgets%20to%20close%20the%20file%20when%20they%20go%20to%20lunch...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20around%20this%20or%20does%20anybody%20know%20why%20it%20happens%3F%20This%20is%20one%20of%20two%20workbooks%20we%20encounter%20this%20problem%20with.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-307976%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eread%20only%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-308411%22%20slang%3D%22en-US%22%3ERe%3A%20File%20locked%20for%20editing%20-%20always%20same%20person%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-308411%22%20slang%3D%22en-US%22%3E%3CP%3EOkay%2C%20so%20I%20solved%20this%20today.%3C%2FP%3E%3CP%3EApparently%20it%20had%20to%20do%20with%20a%20corrupted%20temp%20file%20related%20to%20the%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20that%20needed%20to%20be%20done%20was%20to%20go%20into%20the%20folder%20view%20options%2C%20unchecking%22Hide%20protected%20operating%20system%20files%22%20and%20then%20removing%20the%20'~%24%3CEM%3EFileName%3C%2FEM%3E.xlsm'%20file.%20This%20also%20seems%20to%20have%20sped%20up%20the%20process%20of%20opening%20the%20workbook%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Oliver Razpotnik
Occasional Contributor

We have a workbook that is worked in by multiple people. When the file is opened by someone else and you try opening it, it prevents you from opening it in edit mode - just like it should.

 

The problem we are having is that it always says that the file is opened by this one person, even if this is not the case. This makes for a lot of frustration ("who has the file opened?") since we don't know who has it. The same can be said for when someone forgets to close the file when they go to lunch...

 

Is there a way around this or does anybody know why it happens? This is one of two workbooks we encounter this problem with.

1 Reply

Okay, so I solved this today.

Apparently it had to do with a corrupted temp file related to the workbook.

 

All that needed to be done was to go into the folder view options, unchecking"Hide protected operating system files" and then removing the '~$FileName.xlsm' file. This also seems to have sped up the process of opening the workbook :)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies