How to close a shared file if it doesn't want to close?

C

cherry_velly2019-11-21 07:21:26

excel

cherry_velly, 2019-11-21 07:21:26

Actually, the subject was asked in the flow , but no one wants to answer, and I probably asked the question crookedly.
Faced such a problem. There are two Win2016 virtual machines, not in a domain, made as a file cleaner and a remote desktop server. Users cling to RDP on one, and work with files on another (oh, don't say, not my creation, and I'm trying to get rid of it now, but ...). Analysts and simple workers work with Excel files. That the first, that the second edit them. And sometimes collapse happens. Someone can't close. As if there is nothing to do - you go into the management of open files, right-click and close. Where could be the trick? Actually, the catch is that when you try to open the file, it says that they are supposedly still being used. You try to close the user session - nothing changes. But when you go to the task manager of another server, you close the disconnected session of this user,
What might be the first thought? Apparently the connection somewhere between the two servers is buggy, or the problem is in the primitive sharing of folders. For I have a Win2008 server with DFS in another place of employment, and everything is in order there.
Since I need to get away from this, I decided to first deploy a test "stand" with almost fully configured AD and DFS.
Set up a server, domain, namespace with a test folder. Set up a virtual PC, added it to the domain. Created two users: "buh" and "law". Created an excel file.
We model the situation.
Buh opens a test file, starts editing it and goes somewhere.
Law tries to open this file, swearing comes to me, I go to the management of open shared files and folders and see that boo has opened two files

I close them and tell the law that everything is fire and it can continue to work. But it was not there. The file is still locked.

I climbed the Internet, I did not find anything. I found related topics where the user closes the file, but the server thinks it does not close. But nevertheless (I do not deny that I could overlook) I did not find an answer that satisfies me.
Help me cope with this problem, or tell me some effective lotions that will help you competently manage shared files on the server Windows.

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

A

Anton Shamanov, 2019-11-21
@SilenceOfWinter

put a version control system like git

A

ArgosX, 2019-11-21
@ArgosX

Is Kaspersky Anti-Virus (KES) version 11.2.0.2254 worth it?

S

Sergey, 2019-11-21
@feanor7

And if from the command line?
winitpro.ru/index.php/2018/02/12/smb-open-files-on...
In general, if there are few such files, set up sharing in Excel itself and you will be happy.
If there are many, then just dig about logoff when rdp is disabled.
Maybe someone will have more ideas.

A

Alexander, 2019-11-21
@UPSA

I'll add ...
Did you close the Excel process?
I suppose that Excel is going crazy: "I opened the file. And I remember the name. TESTTESTTEST.xlsx. Probably something with the disk (flash drive)."
You close access to the file, but the opening of the file always goes through the OS kernel. You also need to close the file descriptor in the OS - well, so that the system considers the file closed.