Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: File in use-read only error

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Some excel files shared on server open in read only format, and says file in use by (username), when in fact the file is not in use. Only way to save the file is to a new name, then the new file will give the same message when you re-open it. This happens on some but not all excel files on some but not all folders on the network. Have checked permissions and all, they are correct. It just started doing it about a week ago, was fine before that

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    My ignorant solution.
    If all setting on workbook are correct...
    ...REBOOT!
    Works for me!
    Tom

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-01 09:25, TsTom wrote:
    Hi
    My ignorant solution.
    If all setting on workbook are correct...
    ...REBOOT!
    Works for me!
    Tom
    To add on TsTom comments:

    Please do not NOT... ever just re=boot.

    REboot is not good to do in the tence here can leqd to all kinds of problems memory issues the list is long

    sorty if ive stepped in but PLEASE PLEASE cold boot!

    Cold boot mean shut down switch off 2 mins MINIMUM and switch on... the gap distroys all the held data in bios memory and the windows settings its self,

    this FORCES Windows Bios to re load,,, its safer and stop the bigger pain of all dirty memory.

    again sorry to correct and step in but i just felt this is a simple addition, just try to help. no offence ment i assure you .

    if you still have more problem TsTOM and myself im sure will offer ideas,..
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for your input, but shutdown and reboot didn't help the problem. Excel creates some sort of mirror copy of the files with a .xls.in2 extension instead of just the .xls. When it does this, the original file always comes up as read only and can't be saved under the original name.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    .xls.in2

    In all my years i have never hurd of that one, i suggest the copy over trick into a new work book.

    But try insert new shhet befor 3rd sheet select cell A1 and save re open and save as.. poss will relaease the document.. if not try copy over..

    sorry lost on that one, a tip o the hat...
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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