Multiple users are able to edit same Excel file on server

Hello,

One of the employees at our company has reported an issue with some spreadsheets they use in their department. This spreadsheet(s) is allowing multiple users to edit the file without requiring one of them to be read only. They have not shared the file and have not selected the checkbox allowing more than one user at a time. This has caused these users to overwrite the changes of the other. What could be causing this and how do we correct it? I have never come across an issue similar to this one.

Thank you,

David Alge

August 21st, 2015 9:15pm

Hi David Alge,

Based on your description, my understanding is that multiple users can edited a Workbook on server, but the Workbook is not a shared file.

Is my understanding correct?

I tested your issue in my own environment (Windows 10 & Excel 2013). I created a sample file without Share Workbook and Allow Users to Edit Ranges options, then I saved the Workbook on network.

I noticed that if the permission of Folder for the user S is Read/Write he can also edit the Workbook on network.

I suggest you check the permission of the folder for users. Maybe this is the reason of your issue.

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su

Free Windows Admin Tool Kit Click here and download it now
August 24th, 2015 3:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics