how to delete duplicate file example route 2_2:1 or route 2_2:2

Discussion in 'Microsoft Excel Misc' started by Guest, Oct 8, 2006.

  1. Guest

    Guest Guest

    i was working with a file named route2 and somehow it changed to route2_2:1
    and route2_2:2. How do I delete the new files and return to the origina?. How
    did I create the new files????
     
    Guest, Oct 8, 2006
    #1
    1. Advertisements

  2. Guest

    Nick Hodge Guest

    Paul

    These are just windows of the same file (Window>New), just close one, you
    are not closing the file, just the window and then save the file

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England

    HIS
    www.nickhodge.co.uk

    "Paul" <> wrote in message
    news:...
    >i was working with a file named route2 and somehow it changed to route2_2:1
    > and route2_2:2. How do I delete the new files and return to the origina?.
    > How
    > did I create the new files????
     
    Nick Hodge, Oct 8, 2006
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    Re: how to delete duplicate file example route 2_2:1 or route 2_2

    Thanks for the reply Nick. On my memory stick the file shows as route 2. When
    I open it it opens up as route 2:1 and route 2:2 under the window drop down.
    I tried closing one of the files but it closes both versions at he same time
    so I cannot save the original. Any other suggestion and how did I create this
    mess?

    "Nick Hodge" wrote:

    > Paul
    >
    > These are just windows of the same file (Window>New), just close one, you
    > are not closing the file, just the window and then save the file
    >
    > --
    > HTH
    > Nick Hodge
    > Microsoft MVP - Excel
    > Southampton, England
    >
    > HIS
    > www.nickhodge.co.uk
    >
    > "Paul" <> wrote in message
    > news:...
    > >i was working with a file named route2 and somehow it changed to route2_2:1
    > > and route2_2:2. How do I delete the new files and return to the origina?.
    > > How
    > > did I create the new files????

    >
    >
    >
     
    Guest, Oct 8, 2006
    #3
  4. Guest

    Ragdyer Guest

    Re: how to delete duplicate file example route 2_2:1 or route 2_2

    If you're displaying the 2:2 window, and you hit:
    <Ctrl> <W>
    You'll see the 2:2 change to 2, meaning you closed *only* the duplicate
    window.

    NOW, save the file while there's *no :2*.

    As Nick explained,
    Each time you click (accidentally or intentionally),
    <Window> <New Window>,
    You create a *copy* of the sheet.
    This is great for being able to display different sections of the same sheet
    *or* file at the same time, by going back into <Window>, and choosing
    <Arrange>, and configuring your screen to different display modes.
    --
    HTH,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------
    "Paul" <> wrote in message
    news:...
    > Thanks for the reply Nick. On my memory stick the file shows as route 2.

    When
    > I open it it opens up as route 2:1 and route 2:2 under the window drop

    down.
    > I tried closing one of the files but it closes both versions at he same

    time
    > so I cannot save the original. Any other suggestion and how did I create

    this
    > mess?
    >
    > "Nick Hodge" wrote:
    >
    > > Paul
    > >
    > > These are just windows of the same file (Window>New), just close one,

    you
    > > are not closing the file, just the window and then save the file
    > >
    > > --
    > > HTH
    > > Nick Hodge
    > > Microsoft MVP - Excel
    > > Southampton, England
    > >
    > > HIS
    > > www.nickhodge.co.uk
    > >
    > > "Paul" <> wrote in message
    > > news:...
    > > >i was working with a file named route2 and somehow it changed to

    route2_2:1
    > > > and route2_2:2. How do I delete the new files and return to the

    origina?.
    > > > How
    > > > did I create the new files????

    > >
    > >
    > >
     
    Ragdyer, Oct 8, 2006
    #4
  5. Guest

    Nick Hodge Guest

    Re: how to delete duplicate file example route 2_2:1 or route 2_2

    Paul

    Just click the red 'x' just below the top 'x' which closes the application
    and you should still have one window open, save in this state

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England

    HIS
    www.nickhodge.co.uk

    "Paul" <> wrote in message
    news:...
    > Thanks for the reply Nick. On my memory stick the file shows as route 2.
    > When
    > I open it it opens up as route 2:1 and route 2:2 under the window drop
    > down.
    > I tried closing one of the files but it closes both versions at he same
    > time
    > so I cannot save the original. Any other suggestion and how did I create
    > this
    > mess?
    >
    > "Nick Hodge" wrote:
    >
    >> Paul
    >>
    >> These are just windows of the same file (Window>New), just close one, you
    >> are not closing the file, just the window and then save the file
    >>
    >> --
    >> HTH
    >> Nick Hodge
    >> Microsoft MVP - Excel
    >> Southampton, England
    >>
    >> HIS
    >> www.nickhodge.co.uk
    >>
    >> "Paul" <> wrote in message
    >> news:...
    >> >i was working with a file named route2 and somehow it changed to
    >> >route2_2:1
    >> > and route2_2:2. How do I delete the new files and return to the
    >> > origina?.
    >> > How
    >> > did I create the new files????

    >>
    >>
    >>
     
    Nick Hodge, Oct 8, 2006
    #5
  6. Guest

    Guest Guest

    Re: how to delete duplicate file example route 2_2:1 or route 2_2

    Thanks you solved my problem

    "Ragdyer" wrote:

    > If you're displaying the 2:2 window, and you hit:
    > <Ctrl> <W>
    > You'll see the 2:2 change to 2, meaning you closed *only* the duplicate
    > window.
    >
    > NOW, save the file while there's *no :2*.
    >
    > As Nick explained,
    > Each time you click (accidentally or intentionally),
    > <Window> <New Window>,
    > You create a *copy* of the sheet.
    > This is great for being able to display different sections of the same sheet
    > *or* file at the same time, by going back into <Window>, and choosing
    > <Arrange>, and configuring your screen to different display modes.
    > --
    > HTH,
    >
    > RD
    >
    > ---------------------------------------------------------------------------
    > Please keep all correspondence within the NewsGroup, so all may benefit !
    > ---------------------------------------------------------------------------
    > "Paul" <> wrote in message
    > news:...
    > > Thanks for the reply Nick. On my memory stick the file shows as route 2.

    > When
    > > I open it it opens up as route 2:1 and route 2:2 under the window drop

    > down.
    > > I tried closing one of the files but it closes both versions at he same

    > time
    > > so I cannot save the original. Any other suggestion and how did I create

    > this
    > > mess?
    > >
    > > "Nick Hodge" wrote:
    > >
    > > > Paul
    > > >
    > > > These are just windows of the same file (Window>New), just close one,

    > you
    > > > are not closing the file, just the window and then save the file
    > > >
    > > > --
    > > > HTH
    > > > Nick Hodge
    > > > Microsoft MVP - Excel
    > > > Southampton, England
    > > >
    > > > HIS
    > > > www.nickhodge.co.uk
    > > >
    > > > "Paul" <> wrote in message
    > > > news:...
    > > > >i was working with a file named route2 and somehow it changed to

    > route2_2:1
    > > > > and route2_2:2. How do I delete the new files and return to the

    > origina?.
    > > > > How
    > > > > did I create the new files????
    > > >
    > > >
    > > >

    >
    >
     
    Guest, Oct 8, 2006
    #6
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. doc

    Need macro to auto delete as in example

    doc, Oct 14, 2003, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    290
    Dave Peterson
    Oct 16, 2003
  2. keong04

    "Excel duplicate problem-Duplicate Data"

    keong04, May 19, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    588
  3. H.

    macro question with example file....

    H., Apr 24, 2006, in forum: Microsoft Excel Misc
    Replies:
    3
    Views:
    128
  4. Guest
    Replies:
    1
    Views:
    277
    Guest
    Aug 28, 2006
  5. Need2Noe
    Replies:
    2
    Views:
    140
    Gord Dibben
    Feb 5, 2009
Loading...

Share This Page