Sometime employees can edit read-only Excel file from network share

Question

Hello,
inside company we upgrade all MS Office to MS Office 365 edition with success.
Inside company there is a file server (Windows Server 2008 R2 that we will upgrade soon).
All company PC are running Windows 10 Professional.

Sometime employees complain this strange behavior:

• The first employee open excel file (they can edit it)
• The second employee open the same excel file from the shared folder. In this moment, the second employee can just read file (read only mode).
• The second employee, after some time, can edit the file and the first employee "lost" edit permissions!

Computers' workmates don't lost network connection...

MS Office 365 software is update to the latest version on all company PC (We enabled auto update in MS Office XML setting file).

Finally just to "backup" computer, we enabled OneDrive sync on all company computers, but company documents are shared on file server (SMB shares).

Any suggestion to solve this issue?

Thanks a lot for your support
Federico

Answer 1

Hi @Federico Coppola

Is there any message shown when the second employee open this shared wirkbook?

I suggest you go to the Review tab, click Share Workbook (Legacy) and click Editing tab, check whether there is "Allow changes by more than one user at the same time", if yes, ensure it is ticked.

Besides, please try turning off "Details" and "Preview" in File Explorer.

Any updates, you can post here.

---

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.

---

Answer 2

Hi @Emily Hua-MSFT

> Is there any message shown when the second employee open this shared wirkbook?

I know that the first employee doesn't get any pop-up message.

> I suggest you go to the Review tab, click Share Workbook (Legacy) and click Editing tab, check whether there is "Allow changes by more than one user at the same time", if yes, ensure it is ticked.

I should check these settings.

Best regards
Federico