locked excel file Solved

Question

Hello,

I have certain Excel files on my company's network that, when I open them, give me a message (example):

"This file is currently in use by john.doe, open in read-only mode?"

Nothing too incredible here, except that the john.doe in question is not the one on the Excel file but rather another user (e.g., darth.vador) who is on it. I've checked, and no one in the company is logged into the network with the john.doe login at that moment.
This means that when a user opens an Excel file locked by another user, the name of the user locking the file returned by the system is not the correct one!!!

Has this ever happened to anyone? Is it an Active Directory issue? Any ideas?

Thanks in advance for your responses.

PS: The names are purely fictional for confidentiality reasons.

Configuration: Windows Vista Internet Explorer 7.0

norwyne · Accepted Answer

Rapace, did you find the solution "even if the topic is a bit old" because I have the same problem in my company?

Ankhsuamon · Answer

Hi,

I didn't really follow your issue, but here's how it works.
For a file to be locked, a user needs to be opened in the file.
Now if the user is no longer on that file, there may have been a problem during the closing. Consequently, the Excel process isn't perfectly closed.
Ask the user to quit all their Excel documents (remember to back up) then check the Excel processes in the task manager.
Kill all existing Excel processes. The problem should be resolved.
--
It's amazing how much easier it is for a team to work together, when no one has any idea where they're going.

Ankhsuamon · Answer

Hello,

Another idea. It is possible to create a file by entering your name (Tools\Options|General\Username). This means that when the file is opened a second time, the name returned is not the network name but the one saved in the file.
As a result, user1 is on the file, user3 opens the file and sees a message: User5 locks the file...
Other than that, I don't see anything else.

--
It's amazing how much easier it is for a team to work together when no one has any idea where they're going.

Magorer · Answer

I know it's been a while, but we had the same issue in our company and our research led us to the protection of the workbook.
When the workbook is protected, the name that will be displayed is that of the last person who modified the workbook. However, if the workbook is not protected, it’s the real person's name that is inside.
I don't have a more logical explanation. But if the person who opens it saves it, it will be their name that shows up for others.
Have a good day.

Shill · Answer

The correct answer is probably over there: http://www.infoprat.net/astuces/windows2k_xp/astuces/fichiers_001.php

abdel.btr · Answer

Hello, I have the same problem with a shared Excel file for multiple departments. Closing it causes issues (it remains open on the server even though the person closes it) => solution found, I set it to full control in security (of the file)... I did some tests and it closes!! Good luck!

Locked excel file

6 réponses

Samsung j5 unable to answer

Scam of the suvedene highway

Minecraft restore the cursor and the bar.

My ps3 keeps shutting down on its own...

Samsung series 4 led tv logo display...

How to enable bluetooth on a samsung tv?

Ctrl key issue

[metin2] sura ...

Freebox tv locked step 2 or network

Error 46 (brother dcp-150c) cleaning impossible