Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    new york city
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Two Versions of Same Workbook? (Excel 97/Windows NT)

    A user seems to have two versions of the same workbook running simultaneously. Someone else accessed the file and when they saved it seem to have created two versions that open together and update simultaneously.

    Here's what I mean: the creator made one file. The co-worker used the file, creating two versions. The creator now gets two versions when she tries to open the one file. Any changes she makes to one file is automatically made to the second file. We would like to get rid of the second file.

    The original file name was "wallacecalc FY04-prep.1-03dw$17.7M"
    Now, in the title bar, the original file appears "wallacecalc FY04-prep.1-03dw$17.7M:1"
    and the second file appears "wallacecalc FY04-prep.1-03dw$17.7M:2"

    I have no idea what is going on here? Does Excel offer multiple versions of a file? Is this a scenario (I've never used scenarios)? How can we get this back to one file?

    Many thanks! <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Two Versions of Same Workbook? (Excel 97/Windows NT)

    They are NOT 2 versions, they have 2 WINDOWS open.

    If you would click the restore button in the upper right you can see both windows and resize them. It is 2 views of the same workbook. You can close either one and resave and only one window will open.
    Window - New window adds these extra windows.

    Steve

  3. #3
    Star Lounger
    Join Date
    Apr 2001
    Location
    new york city
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Two Versions of Same Workbook? (Excel 97/Windows NT)

    Ergh! Don't I feel silly.

    Thank you for the assistance. I would never have figured that out on my own.

    Cheers.

Posting Permissions

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