1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Error caused excel file to file in Use and read-only

Discussion in 'Business Applications' started by HOBOcs, Apr 26, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. HOBOcs

    HOBOcs Thread Starter

    Joined:
    Jan 5, 2004
    Messages:
    8,516
    First Name:
    Jim
    I've got Excel 2000. (Win98)
    The PC froze / hung-up while in excel. Could only power off to restart.
    Now when you access the file you get a message that the "file is in use" and can only be opened in read only mode.

    "When you open a file that is in use, you'll get a message that tells you the file must be opened in read-only mode. In some cases, you may get this message even though the file is definitely not in use. This can be caused by an Excel crash, in which the file was not released."

    The file was being accessed on another PC via a basic household network.
    Our work around at present was to access the file in Read-only mode and save it as a new file. The old file still exists. I can't delete it as I get the same file in use message.

    But, I'm still working on the older file to see if I can unlock it some how.
    Tried the following:
    1) Check/deleted temp files on the editing PC.
    2) Checked the file attributes on the file (Note: the file did not have the "Read-only" attribute ticked)
    3) Now checking the source PC for temp files.

    Any direction greatly appreciated.
     
  2. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Save yourself some time.
    Open the old file.
    Right-click a sheet tab and hit Select all sheets.
    Right-click again and hit Move or Copy.
    Choose the create a copy box, and from the dropdown, choose New book.
    Save the new book. Make sure all is well. Delete the old book.
     
  3. HOBOcs

    HOBOcs Thread Starter

    Joined:
    Jan 5, 2004
    Messages:
    8,516
    First Name:
    Jim
    Issue Resolved:
    When I checked the "source" PC for network connections, I found (using systems tools / Net Watcher) the "editing" PC was still showing as connected with the file open (Even after we rebooted the editing PC). I removed/deleted the connections and all appears right with the world. (I can access the file to edit)

    Thnx DB for the tip regardless.
     
  4. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/224193

  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.
    Dismiss Notice