Excel document in shared server folder, opened by another user

Gilbert Mani 20 Reputation points
2024-05-21T11:30:01.57+00:00

Good morning,

I wanted to ask if any of you have ever encountered the following problem.

If a colleague opens an excel document, which is on a shared folder on a file server, the following error appears:

File in use

Open Read Only or click Notify to open read only and receive notification when the document is no longer in use

Is there a way to see directly on the attached message who the person is who is using this file, without having to go through the file server and check computer management-open files etc.? ?

Thank you

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,384 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,591 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,398 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emi Zhang-MSFT 22,871 Reputation points Microsoft Vendor
    2024-05-22T07:38:20.27+00:00

    Hi,

    This error may be caused by the user did not delete the temporary file when closing the file, the user not having the permission to delete the file. It is recommended that you check whether there are any temporary files with a hidden prefix of ~$ in the folder where the file is located, and you can delete it manually.

    This problem mainly requires users to have enough read, write and delete permissions, and it is recommended to check the permissions of users.

    About how to know who has locked the file, first you need to set the username in Excel, you can go to File - Options - General - to find the User Name option, make sure that all users have the name written on it.

    At the same time, you can also set Clear Office Document Cache- go to File- Options- Save- Under Cache Settings, tick the option "Delete files from the Office Document Cache when they are closed" and click Delete cached files.

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    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.

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Emi Zhang-MSFT 22,871 Reputation points Microsoft Vendor
    2024-05-22T06:45:06.71+00:00

    Hi,

    This is an English language forum, I suggest you transform the language to English. The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    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.

    0 comments No comments

  2. Gilbert Mani 20 Reputation points
    2024-05-22T08:03:38.5733333+00:00

    Thank you Emi,

    Deliting the file with this ~$ helped on the issue.

    Now i can see the name of who is using the file

    KR

    Gilbert