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

Posted on 2009-12-28
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?

Question by:Michael Ebbeson

    Author Comment

    by:Michael Ebbeson
    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.


    Accepted Solution

    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:

    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!  ;)
    LVL 45

    Expert Comment


    Are you sure the file is not 'shared'?


    Author Comment

    by:Michael Ebbeson
    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.

    LVL 45

    Expert Comment

    Michael, At least you've cracked the problem, - Patrick

    Author Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now