Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple workbook sheet numbers!
Hi everyone,
I have a user who when he opens a workbook two versions of the same workbook are opened. In the titlebar the name of the work book appears with the two versions of the same work book denoted by the name followed by a :1 or :2 depending on the version of the workbook. My question is how to I combine these versions so there i only one version of the work book displayed? Please help. JG. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple workbook sheet numbers!
They're the same workbook, just two windows into it. Close all but one
window and the ":x" will go away. In article , JG wrote: Hi everyone, I have a user who when he opens a workbook two versions of the same workbook are opened. In the titlebar the name of the work book appears with the two versions of the same work book denoted by the name followed by a :1 or :2 depending on the version of the workbook. My question is how to I combine these versions so there i only one version of the work book displayed? Please help. JG. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple workbook sheet numbers!
Yes, they are the same workbook, when I close one or the other they both
close which is sending me around the loop, apparently this is a feature of Excel which I would like to turn off. "JE McGimpsey" wrote: They're the same workbook, just two windows into it. Close all but one window and the ":x" will go away. In article , JG wrote: Hi everyone, I have a user who when he opens a workbook two versions of the same workbook are opened. In the titlebar the name of the work book appears with the two versions of the same work book denoted by the name followed by a :1 or :2 depending on the version of the workbook. My question is how to I combine these versions so there i only one version of the work book displayed? Please help. JG. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple workbook sheet numbers!
It's not a feature of XL. Are you sure your user isn't closing XL rather
than the workbook window? The only other thing that comes to mind is a Window Activate or Deactivate event macro In article , JG wrote: Yes, they are the same workbook, when I close one or the other they both close which is sending me around the loop, apparently this is a feature of Excel which I would like to turn off. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple workbook sheet numbers!
You hit the wrong X.
=========== You actually have two windows open to the same workbook. Select the one you don't want anymore and hit ctrl-w Then save the workbook--or you'll be doing it again. This can be a useful feature if you want to see different parts of the workbook at the same time. Window|New window (to create that second window) JG wrote: Yes, they are the same workbook, when I close one or the other they both close which is sending me around the loop, apparently this is a feature of Excel which I would like to turn off. "JE McGimpsey" wrote: They're the same workbook, just two windows into it. Close all but one window and the ":x" will go away. In article , JG wrote: Hi everyone, I have a user who when he opens a workbook two versions of the same workbook are opened. In the titlebar the name of the work book appears with the two versions of the same work book denoted by the name followed by a :1 or :2 depending on the version of the workbook. My question is how to I combine these versions so there i only one version of the work book displayed? Please help. JG. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make multiple copies of a sheet in a new workbook | Excel Worksheet Functions | |||
How do I set up a single header for a multiple sheet workbook? | Excel Discussion (Misc queries) | |||
selecting multiple sheet tabs and open another workbook | Excel Discussion (Misc queries) | |||
Multiple Workbook Data Capture Summary Sheet | Excel Discussion (Misc queries) | |||
Continuous page numbers in workbook of multiple worksheets | Excel Discussion (Misc queries) |