How do I delete one of the following[workbook]:1 and [workbook]:2
 

When I open one particular workbook I get two copies labeled [workbook
name]:1 and [workbook name]:2. Whwn I make changes to one, the second one is
also updated. How do I delete one of the these versions of the same workbook?

How do I delete one of the following[workbook]:1 and [workbook]:2
 

This will have been set up with two windows open to the same file. You
can just close one window (using the X in the top right corner of the
file window, NOT the Excel window), and then save the file. Next time
you open it there will only be one window to the file.

Hope this helps.

Pete

On Oct 23, 4:13*pm, Boston Jerry <Boston
wrote:
When I open one particular workbook I get two copies labeled [workbook
name]:1 and [workbook name]:2. *Whwn I make changes to one, the second one is
also updated. *How do I delete one of the these versions of the same workbook?

How do I delete one of the following[workbook]:1 and [workbook]:2
 

They are not versions of the same workbook, just two windows.

Close one of the windows and save the workbook.

You get these in the first place from going to WindowNew Window


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 08:13:01 -0700, Boston Jerry <Boston
wrote:

When I open one particular workbook I get two copies labeled [workbook
name]:1 and [workbook name]:2. Whwn I make changes to one, the second one is
also updated. How do I delete one of the these versions of the same workbook?

How do I delete one of the following[workbook]:1 and [workbook]:2
 

Select the window you don't want and hit ctrl-w to close it.

Then save your workbook--or you'll have to do it again the next time you open
it.

Boston Jerry wrote:

When I open one particular workbook I get two copies labeled [workbook
name]:1 and [workbook name]:2. Whwn I make changes to one, the second one is
also updated. How do I delete one of the these versions of the same workbook?

--

Dave Peterson