This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi guys,
There is an Excel file created by a user (say User_A).
(This is the only file from many other Excel files that behaves this way.)
Normally when an Excel file is already opened the next user can see who opened that file from a popup warning.
However, with this file no matter who opens this file the next user for some reason gets a notification that the file in use by user User_A.
The problem is that when someone needs to open that file they contact User_A whereas indeed it is opened by someone else.
If someone could shed some light why it could be so and how to fix it that would be great.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 16%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Hi,
This is a bug that's been around in microsoft for many years & there does not appear be a fix, users just need to log a ticket with your IT who can then look at open file session within your file server find the user who is inside & either ask them to close it or if they aren't actually in it end the file session.
regards
Hi,
This is a bug that's been around in microsoft for many years & there does not appear be a fix, users just need to log a ticket with your IT who can then look at open file session within your file server find the user who is inside & either ask them to close it or if they aren't actually in it end the file session.
regards
In 2024 and this problem still remain
Any chance tha microsoft fixing that ?
Hi @Cloud_Geek_82 ,
I suggest you go to the same directory of the problem file and check if there is an hidden file with "~$" symbol with the same file name. If you can find this kind of file, please remove it and confirm if other users can open it. Then please make sure the User A have permission with Delete, try to provide the full permission to the User A.
If this issue still existed, I suggest you confirm if this support article is helpful:
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 25%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
This solution only works if User A1 is really out of the file and it got locked up. Sometimes happens when user forgets he has file open and logs off of network/shuts down PC.
Hi @Emi Zhang-MSFT ,
Deleting ~ file with the same name seems resolved the issue.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 75%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Hi
Same problem. But erasing the ~ file does not do it.
At the end we have to save the file somewhere else. Erase the original file and ~ file if it exists and put the file back in its place.
This problem comes and goes and I don't understand how to make disappear for good and it's really bother us.
Thanks for any ideas.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 31%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Same issue here.
If I go into Excel and "save as" the file to a different name, it fixes the issue.
But if I rename the file back to the original name, it breaks again.
It is showing a user that has not been at the company for three years as the person having the file open. And since that user was last here, the server has been physically upgraded to a new server 2022 (different server, different OS, we just copied the files over) so it's not a server side issue - it's the file itself.