question

FedericoCoppola-2569 avatar image
0 Votes"
FedericoCoppola-2569 asked emilyhua-msft edited

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

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

windows-10-generaloffice-excel-itprooffice-itpro
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.

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

Hi @FedericoCoppola-2569

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.



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.

FedericoCoppola-2569 avatar image
0 Votes"
FedericoCoppola-2569 answered emilyhua-msft edited

Hi @emilyhua-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
· 1
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 @FedericoCoppola-2569
I am checking this thread, is there any update?
If yes, welcome to discuss with us.
Besides, does the second user get any message?

0 Votes 0 ·