We help IT Professionals succeed at work.

Share folder: How to prevent multiple users modify the same file?

Last Modified: 2012-06-27
I have a share folder on 2003 server and several users have write permission. But uer can modify the file even other user already opened it and making modification. How can I prevent this? or is there a better way to workaround?
Watch Question


what file type is it and what application they are using to edit it

On a shared file the last user to save will be the final version. You need sharepont to control this problem and regulate the users who are accessing a file at any given time. It is expensive but it is the way to do what you want.


it's a xsl file. So you are saying the only was is to use sharepoint? no other alternative way?

Sharepoint won't allow sharing of an xsl. It will allow you to convert xsl into html. I am not sure what you are hoping to do but generally speaking a file cannot be edited by more than one person at a time without some service managing those changes. They can use a file then exit and then another can use it and exit and so on.

Here is a link to microsoft on sharepoint http://office.microsoft.com/en-us/sharepoint-server-help/convert-an-xml-file-to-a-web-page-HA010215482.aspx

Perhaps this will help you target you goal more specifically.

Good luck,
Holler if you need help.

Krzysztof PytkoSenior Active Directory Engineer
Top Expert 2012

I'm not sure but this problem is not NTFS permission. NTFS by default disallow using file by more that one person in "modify mode". I would check in that Excel sheet in "Tools -> Share workbook/sheet" if there is checked a box "Allow apply changes concurrently by multiple users" (it's my translation :) but there is only one check box) If it is enabled, just disable it, then users will have a message that "This document is read-only because someone (and they see user login) uses it".

Hope it helps

OK, as it is an Excel file office it will by default prevent sharing documents, so it must be set manually.

In Excel 2003 you can disable it as isiek posted

In Excel 2007/10 you go to Review and klick on share workbook it should not be marked


so it means I have to configure it on each user's excel?? there is no way I can configure on the server, example group policy..... ?
Unlock this solution and get a sample of our free trial.
(No credit card required)

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.