Nov 10 2020 07:31 AM
Nov 11 2020 09:36 AM
Excel shows wrong, blocking user in "Document is in use"?
If I have understood it correctly and it is so, then you will find the suggested solution below.
But if I am totally won over with the translation, please ignore my contribution.
If you delete the "~" file, the information will be displayed correctly the next time it is opened.
If you take a look at the "~" file with an editor, you can see that the editing user is noted in it.
Most noticeable is the outdated creation date.
In general, you could search for such files on your file server and delete all files older than two days!
Why the wrong name? When you open an Office file, a temporary file with a "~" in front of it is created in the same directory (e.g .: ~ $ Mappe1.xlsx). This records which user has opened the file. Normally the "~" file should be deleted automatically after it is closed. No NEW "~" file can be created the next time it is opened and the user information is retained. If another user tries to open the file, the outdated information is displayed.
I would be happy to know if I could help.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.