Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Friday, August 21, 2015 9:15 PM
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
All replies (5)
Wednesday, August 26, 2015 9:45 AM âś…Answered
Hi dbalge,
I suggest you refer to this article:
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/05/14/the-definitive-locked-file-post.aspx
If you want users open the file with a pop up dialog box about user in use, you can remove the full control from this file.
Hope it's helpful.
Regards,
Emi Zhang
TechNet Community Support
It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs. Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [email protected].
Monday, August 24, 2015 7:21 AM
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 Support
It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs. Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [email protected].
Monday, August 24, 2015 5:26 PM
Yes, that is correct. We have a departmental share folder setup and users in the department are granted either read/write or read only, depending on how the department wants their permissions. The problem is the following:
User A
Opens Workbook.xlsx from the server. Excel shows read/write
User B
Opens Workbook.xlsx from the server. Does not notify user that User A has the file open.
Both User A and User B make changes to the workbook. User B saves the file and exits. User A saves the file and exits.
One of these users opens the file again and all of User B's changes are lost because User A was the last person to save the file and it overwrote the changes that User B did.
We need to find out why when User B opened the file AFTER User A, that it did not show the popup box and give the option to open in read only mode.
Thank you,
David Alge
Tuesday, February 27, 2018 12:05 PM
I just wanted to share the findings of my 3-hour Google research I did on this subject. Many threads on different forums with no helpful answer... In case you're using GPOs to map a network drive the link below could be a solution. I literally only registered here to write this so I am not allowed to post an actual link yet.
Friday, June 12, 2020 5:12 AM
Hi David,
Did you find the solution for this issue?
I am facing same here.
Thanks,
Shikha