question

ITGeek82-8422 avatar image
1 Vote"
ITGeek82-8422 asked aaronatkinson-9338 published

Excel File in Use - wrong user

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.

55489-excel-nb.jpg

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.


office-excel-itpro
excel-nb.jpg (29.3 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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

0 Votes 0 ·
emizhang-msft avatar image
0 Votes"
emizhang-msft answered

Hi @ITGeek82-8422,
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:

https://support.microsoft.com/en-us/office/excel-file-is-locked-for-editing-6fa93887-2c2c-45f0-abcc-31b04aed68b3


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.





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ITGeek82-8422 avatar image
0 Votes"
ITGeek82-8422 answered

Hi @emizhang-msft,

Deleting ~ file with the same name seems resolved the issue.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GHAVAMIANCharles-3430 avatar image
0 Votes"
GHAVAMIANCharles-3430 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.