Share via

Problem with Excel file on network share and edit queue

Pavel.Dyachuk 251 Reputation points
2023-02-09T12:02:55.0766667+00:00

Hello. There is an Excel file on the network share. It needs to be opened and edited by multiple people. Accordingly, when the first user opens for editing, he is blocked for the rest and when trying to open it, Excel will inform them about it and give the option to open for reading or notify them of the availability for editing. So here's the problem - the first user does not close Excel and enters data, at some point Excel believes that the editing is completed and gives access to another user without notifying the first user about it. The first tries to save his changes and gets an error because now another user is editing the file. I can not understand what provokes this behavior and how to get rid of it.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,322 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,682 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 23,736 Reputation points Microsoft Vendor
    2023-02-10T09:38:08.1933333+00:00

    Hi @Pavel.Dyachuk,

    Did you enable the Shared feature in Excel?

    I suggest you check users' permission for accessing the shared folder in Network.

    Try to test the Administrator accounts for the shared folder.

    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.