Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Ontario, Canada
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    When opening a single file, it creates two copies! (Excel 97)

    I have one Excel file that has suddenly started very strange behaviour. When I open it in Excel, it loads two copies into memory and uniquely identifies them by appending a colon and then a number. For example, if the file name was myfile.xls, when it is opened it creates myfile.xls:1 and myfile.xls:2 in Excel. If one makes changes to one copy, they are simultaneously done in the other copy!!

    What on earth would have caused this psychotic behaviour? It only happened to one file and it happened all of a sudden.

    Drew

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: When opening a single file, it creates two copies! (Excel 97)

    all you've done here is open a second window on the same workbook - window / new window - just close one of them and then save and the :2 should dissappear

    HTH

    Brooke

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Ontario, Canada
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: When opening a single file, it creates two copies! (Excel 97)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    Oh do I feel a bit sheepish!

    I was actually asked by another employee what he had done to do this and I could not for the life of me figure it out. He claimed he merely turned in his chair and as he turned, he hit some key(s) on the keyboard and Wha-La! the second window was open. So, it makes sense it was a real easy fix since it was created so easily.

    THANKS!!

Posting Permissions

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