If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filenames ending with :1 and :2
I don't know how this happened....
I have two documents that open at the same time (one has a :1 and the other a :2 at the end of the file name) When I make a change to one, the change automatically happens to the other. How do I close these documents and get back to working with the original/main document? Thanks. |
#2
|
|||
|
|||
Filenames ending with :1 and :2
You haven't got two documents open, you've opened two windows on the same
document. Close one (not with the red X at the top right which closes the whole instance of Excel, but with the smaller blue X just below it), then save the workbook. Reopen & you'll just see the one window. -- David Biddulph "djn" wrote in message ... I don't know how this happened.... I have two documents that open at the same time (one has a :1 and the other a :2 at the end of the file name) When I make a change to one, the change automatically happens to the other. How do I close these documents and get back to working with the original/main document? Thanks. |
#3
|
|||
|
|||
Filenames ending with :1 and :2
Hi,
At some time in the past either by accident or design someone has entered Window/New Window. Close one of the windows and save and all will be well Mike -- When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "djn" wrote: I don't know how this happened.... I have two documents that open at the same time (one has a :1 and the other a :2 at the end of the file name) When I make a change to one, the change automatically happens to the other. How do I close these documents and get back to working with the original/main document? Thanks. |
#4
|
|||
|
|||
Filenames ending with :1 and :2
And by the way, you close one window by the "X" in the upper right corner,
not by File/Close! Bob Umlas Excel MVP "Mike H" wrote: Hi, At some time in the past either by accident or design someone has entered Window/New Window. Close one of the windows and save and all will be well Mike -- When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "djn" wrote: I don't know how this happened.... I have two documents that open at the same time (one has a :1 and the other a :2 at the end of the file name) When I make a change to one, the change automatically happens to the other. How do I close these documents and get back to working with the original/main document? Thanks. |
#5
|
|||
|
|||
Filenames ending with :1 and :2
Just to add another way to close one of the windows...
Select the one you don't want and hit ctrl-F4. Then save the workbook--or you may be doing it again. djn wrote: I don't know how this happened.... I have two documents that open at the same time (one has a :1 and the other a :2 at the end of the file name) When I make a change to one, the change automatically happens to the other. How do I close these documents and get back to working with the original/main document? Thanks. -- Dave Peterson |
#6
|
|||
|
|||
Filenames ending with :1 and :2
Bob
Good point but OP please note it isn't the big X in the top right corner, that closes the application and not the window, it's the lower of the 2 X's in the upper right. -- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. Occam''s razor (Abbrev) "Bob Umlas, Excel MVP" wrote: And by the way, you close one window by the "X" in the upper right corner, not by File/Close! Bob Umlas Excel MVP "Mike H" wrote: Hi, At some time in the past either by accident or design someone has entered Window/New Window. Close one of the windows and save and all will be well Mike -- When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "djn" wrote: I don't know how this happened.... I have two documents that open at the same time (one has a :1 and the other a :2 at the end of the file name) When I make a change to one, the change automatically happens to the other. How do I close these documents and get back to working with the original/main document? Thanks. |
#7
|
|||
|
|||
Filenames ending with :1 and :2
Thank you.
"Mike H" wrote: Bob Good point but OP please note it isn't the big X in the top right corner, that closes the application and not the window, it's the lower of the 2 X's in the upper right. -- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. Occam''s razor (Abbrev) "Bob Umlas, Excel MVP" wrote: And by the way, you close one window by the "X" in the upper right corner, not by File/Close! Bob Umlas Excel MVP "Mike H" wrote: Hi, At some time in the past either by accident or design someone has entered Window/New Window. Close one of the windows and save and all will be well Mike -- When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "djn" wrote: I don't know how this happened.... I have two documents that open at the same time (one has a :1 and the other a :2 at the end of the file name) When I make a change to one, the change automatically happens to the other. How do I close these documents and get back to working with the original/main document? Thanks. |
#8
|
|||
|
|||
Filenames ending with :1 and :2
Thank you.
"Dave Peterson" wrote: Just to add another way to close one of the windows... Select the one you don't want and hit ctrl-F4. Then save the workbook--or you may be doing it again. djn wrote: I don't know how this happened.... I have two documents that open at the same time (one has a :1 and the other a :2 at the end of the file name) When I make a change to one, the change automatically happens to the other. How do I close these documents and get back to working with the original/main document? Thanks. -- Dave Peterson . |
Thread Tools | |
Display Modes | |
|
|