1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Excel Locked to Editing by

Discussion in 'Other PC Software' started by andrew simons, 2007/11/26.

  1. 2007/11/26
    andrew simons

    andrew simons Inactive Thread Starter

    Joined:
    2007/11/26
    Messages:
    3
    Likes Received:
    0
    I have an excel 2003 workbook on a server at work which when opened it comes up with the error: <File Name> is locked for editing
    by '<User Name>'.

    The person listed did not have the file open so i created a copy of the workbook with a new name so we could keep using the woorkbook. The new file opened once and then the next time it opened the same error occured with my name as holding the file open even though i didn't have it open.

    I read on microsofts website that having the file not as deep in folders on the server would fix the problem but it occurs nomatter where i create a copy of the file. The file always opens once before locking up.

    Help would be much appreciated as i spent alot of time creating this workbook and i don't want to have to do it again.

    Andrew
     
    andrew simons,
    #1
  2. 2007/11/27
    Arie

    Arie Administrator Administrator Staff

    Joined:
    2001/12/27
    Messages:
    15,174
    Likes Received:
    412
    Is the workstation set to AutoDisconnect? This is something that XP is capable of.

    In the Registry take a look at the autodisconnect value at:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters

    If it is set to zero(0) then that could explain the problem. Zero doesn't turn it off - it sets it to disconnect in a matter of seconds

    The default is f (in Hex), which is 15 minutes.

    What this setting does is it autodisconnects the network after the network has been idle for the duration of the autodisconnect value.

    Intel suggest setting this to 8,171 years, which I think is stupid & asking for potential problems, but in your case I'd try setting it to 12 or 24 hours (2d0 or 5a0).

    What may be happening is that the workstation is getting disconnected, in which case Excel is unable to delete the temp file called the "Owner file ". This temp file is stored in the same location as the document and holds the user info for the person that has the document open.
     
    Arie,
    #2


  3. to hide this advert.

  4. 2007/11/27
    andrew simons

    andrew simons Inactive Thread Starter

    Joined:
    2007/11/26
    Messages:
    3
    Likes Received:
    0
    It was set to the defult value. I've changed the value to 12 hours and made a copy of the workbook and the new copy appears to be working perfectly.

    I don't know much about the registry as i've never really looked at it before, willl that value stay set to 12 hours no mater who is logged onto the machine?

    Also in my attempts to work out the problem I have ended up with multiple copies of the woorkbook. How can I get rid of these as excel still thinks people are holding them open.

    Cheers Andrew
     
    andrew simons,
    #3
  5. 2007/11/27
    Arie

    Arie Administrator Administrator Staff

    Joined:
    2001/12/27
    Messages:
    15,174
    Likes Received:
    412

    Yes, HKEY_LOCAL_MACHINE settings apply for the whole machine.
     
    Arie,
    #4
  6. 2007/11/28
    andrew simons

    andrew simons Inactive Thread Starter

    Joined:
    2007/11/26
    Messages:
    3
    Likes Received:
    0
    Ok. Thanks for that mate, i'lll have to go around and update the computers on our network.

    Cheers, Andrew
     
    andrew simons,
    #5
  7. 2007/11/28
    Arie

    Arie Administrator Administrator Staff

    Joined:
    2001/12/27
    Messages:
    15,174
    Likes Received:
    412
    You're welcome.
     
    Arie,
    #6

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...