Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File locked (Excel XP)

    I have five users who need to share a spreadsheet. The spreadsheet is password protected so that other users can view the contents, but not modify.
    My five users need to modify. Each user may make many changes to the spreadsheet throughout the day.
    Since moving to Office XP, users receive an error message that says
    "Unexpected file lock by <user name>. You can override this file lock, or continue without doing so. If you continue without overriding this lock, you will not be able to save this file, but you can use Save As to save your work to a different file. Do you want to override this lock?"
    If you choose to override, you still cannot save any changes to the file. The user whose name is mentioned in this despatch is not in the file any longer, and can sometimes be the user who wants to get in to make further changes.
    Technet has one article about Excel 2000 with the first part of the error message, but a next to useless strategy for fixing.
    I can copy and paste all the data into a new spreadsheet and that will survive for a little while and then this problem recurrs.
    Any suggestions?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: File locked (Excel XP)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> johanna

    OK have you investigated Sharing this workbook?

    I take it that all these users are connected to a network and have a shared location where the workbook can be accessed from.

    If you open the workbook in question, and from the Tools menu you choose Share Workbook, you get a dialog that has a checkbox that allows you to accept changes by more than one user.

    Let this be your first step, and if it does not meet your needs then reply to this message and Loungers will come you your aid as well.

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File locked (Excel XP)

    Yes you are right. The user do share this file from a central location. And yes, the file is shared. It has a password to modify, so users who do not know the password can only read the file.

    When the unexpected file lock occurs, it always has the name of one of the users who has access to the password.

    Most of the users who have access are on PCs with Windows 2000, and a couple still have NT workstation. (dont know if that has any effect.)

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: File locked (Excel XP)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> johanna

    I guess since MS-Excel 2002 is so new, maybe there are some glitches that a Service Pack may help.

    Check if you have all the up-to-date software.

    I have found a glitch with Excel 2002 reading from a USB hard drive. This is till being looked at. So stay tuned.

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    New Lounger
    Join Date
    Mar 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File locked (Excel XP)

    Yes, thank you Wassim,

    Installing SP1 appears to have solved the problem.

    Thanks for your time and assistance

    Johanna

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •