Excel 2016, 2019, 2021 does not prompt the user that the that file is open by another user.

asked 2022-12-07T16:11:20.96+00:00
Andrzej Wojciechowski 41 Reputation points

We have a small smb share with excel documents, recently a problem showed up when users can open documents already opened by another user. There is no prompt that the files is already open and both users have the file open with ability to edit. It happens when file is open for some time, how does Excel know that the file was closed? Can I do something to prevent it?

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,563 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,333 questions
No comments
{count} votes

Accepted answer
  1. answered 2022-12-08T05:24:04.363+00:00
    Emily Hua-MSFT 21,526 Reputation points Microsoft Employee

    Hi @Andrzej Wojciechowski

    I suggest you go to the same directory of the these Excel workbooks and check if there are any hidden file created with "~$" symbol with the same file name after users open Excel workbooks.
    Please make sure users have enough permission for smb share folder.

    Besides, here is a similar thread "Users NOT prompted file is already open by another user?", if users are accessing these files over the network on an SMB share, pleasse check the Group Policy settings for network drives mapping and make sure it is set to Update instead of Replace.
    (Please Note: Since the web site is not hosted by Microsoft, the link may changed without notice. Microsoft does not guarantee the accuracy of this information.)

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    No comments

1 additional answer

Sort by: Most helpful
  1. answered 2022-12-08T12:11:32.547+00:00
    Andrzej Wojciechowski 41 Reputation points

    I checked the GPO of the network drives and indeed the option was set to replace instead of update. I hope it will resolve the issue. Thank you very much!

    No comments