Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Location
    Columbus, OH
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Read only access (2000)

    We have a spreadsheet on node of a network that no person, including the original author can access in read/write mode. The message says the spreadsheet is in use by person 1, but no person has the spreadsheet open. Even person 1 gets that message when he tries to open the spreadsheet.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Re: Read only access (2000)

    Have you tried opening the file, use file-save-as and give it a temporary new name, then use file save-as and save it with the original name??

    zeddy

  3. #3
    New Lounger
    Join Date
    Apr 2001
    Location
    Columbus, OH
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read only access (2000)

    Yes, we tried saving to another name and deleting the original file, but the error message said someone had the file open and therefore could not be deleted. We finally shut down the computer that had edited the file last and that freed the file to be edited in read/write mode. We do not know how the file was open on that computer without the person being aware of it. Maybe excel disappeared and left the file open.

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Re: Read only access (2000)

    It sounds like the file was 'locked' by the operating system.
    If a User has an open file and exits 'ungracefully' - e.g. just switched off the computer or say, a power cut on the PC, then the file will be flagged as still 'open'. Restarting clears the lock. This can happen on a single PC too, e.g. if the program hangs or freezes while the file is open.
    Re-starting a network is a bit drastic - I believe there are Admin utilities which can reset such locked files without having to reboot.

    zeddy

Posting Permissions

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