Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Locked for Editing (2K)

    Working on an Excel workbook and saving as I go, took a break and opened the workbook to continue.
    Dialogue Box "File is locked for editing, Open as read only" .
    OK open as read only rename the file on "Save As", carry on working.
    AT the end of the session I wish to give the new file the original name. Try to delete the orginal file to allow me to reneme the new one.
    Same old message " "File is locked for editing, Open as read only"
    What is happening, and how do I get out of it <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locked for Editing (2K)

    Mike,
    Have you tried rebooting the PC?

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Locked for Editing (2K)

    I should have explained earlier - I am working off a 1.44M floppy. Would this affect the behaviour of the file?

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locked for Editing (2K)

    Mike,
    I would not think it would affect it. Try closing Excel, use the Windows Explorer to delete the unwanted file. Then start Excel and open the remaining one.
    Failing this, I would still recommend a reboot. It is one of the first things I do when things do not make sense. Memory can and does get 'messed up'.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  5. #5
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Locked for Editing (2K)

    It is best not to open & save files directly to floppy for 2 main reasons
    1/ Temporary files are created on the floppy and you could run out of space very quickly
    2/ The chances of the file becoming corrupt is much higher than when writing to a hard disk

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locked for Editing (2K)

    Several things:

    1- It is not usually a good idea to work on a file from a diskette drive. This can cause all kinds of different problems. If it were me, I would copy it to the hard disk, update it there, and then copy it back to a diskette if required.

    2- The message you are seeing can be caused by anti-virus software, particularly if the file is on a diskette. Rebooting will usually solve that problem.

    3- Removing a diskette before delayed write operations have completed can cause a file to become corrupted which can cause problems like you describe (see item 1.) Again, rebooting may help. If rebooting does not help, you may be able to open the file in a later version of Excel if you have access to one.
    Legare Coleman

Posting Permissions

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