Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete duplicates on 2nd workbook | Excel Discussion (Misc queries) | |||
How can I delete all matches in a workbook? | Excel Worksheet Functions | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
in workbook, where is delete worksheet | Excel Worksheet Functions | |||
how do you delete a workbook | Excel Discussion (Misc queries) |