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.

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.

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.

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.

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

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.

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.

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
.