[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

excel file "locked for editing" by either same or different user

Posted on 2009-12-28
6
Medium Priority
?
856 Views
Last Modified: 2012-05-08
I am in the middle of migrating a small office from Windows 2000 to Windows 2003 SBS.  I have copied their main data folder over to the new server and am getting edit lock messages on the excel data files, either being locked by the same person, or a different person.

I designated the new server as a DC but with a different domain name.
The old DC is still online, but the clients having trouble are both ones logging into the new or old domain.

I almost seems like some edit lock is not getting properly released.

I have tried to disable SMB signing on the new server, in group policy but not sure it i did it in the right place.  do i need to disable SMB signing on the old server too?

Thanks.
0
Comment
Question by:Michael Ebbeson
  • 4
  • 2
6 Comments
 

Author Comment

by:Michael Ebbeson
ID: 26133244
info update:
It appears that this lock problem is limited to a specific type of excel spreadsheet the user get, which is somewhat complex, and contains a bunch of macros.

And if they copy the file from the shared network folder to their local C: drive, they do not get the lock message.

Thanks.
0
 

Accepted Solution

by:
Michael Ebbeson earned 0 total points
ID: 26136111
More Info Update:

I'm not certain, and will followup and verify, but it looks like it might have something to do with the Indexing Service that's on Server 2003.  Here's an article i found:

http://www.windowsreference.com/windows-server-2003/fix-for-filename-is-locked-for-editing-by-username-error/

I have disabled the indexing service on the directory that holds these files and popped the server and preliminary results look good.  Dang, should have upped the points if this is the solution!  ;)
0
 
LVL 45

Expert Comment

by:patrickab
ID: 26144365
pgmtech,

Are you sure the file is not 'shared'?

Patrick
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Michael Ebbeson
ID: 26149216
Thanks Patrick for chiming in.

I'm pretty sure it's the index service.

Once i cleared the indexing for that folder as per the above mentioned article, all of the locks just vanished.

Michael
0
 
LVL 45

Expert Comment

by:patrickab
ID: 26149747
Michael, At least you've cracked the problem, - Patrick
0
 

Author Comment

by:Michael Ebbeson
ID: 26149873
yep!  But they won't give me my points! :(
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question