Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel dup copy of workbook
I have many workbooks with several pages in them for the very first time I have a problem I have one workbook that when I open it I get two copies of it in the window when you look at it you see worksheets1200:1 worksheets1200:2 there is only one copy of this worksheet why do I get two copies when I open it? HOW do I change this to the normal one copy only? I do not what two copies I can close one copy and the other one stays open to use if someone can tell me how I set it to open two copies I would appreciated it also please tell how to get it to stop opening two copies thanks Bonnie Proud Marine Mom of LCpl Rick |
#2
|
|||
|
|||
Close either copy. A second view was created under the Window menu.
It allows to to view two different sheets in the smae workbook or two or more views of same worksheet. So you could for instance look at totals and data at the same time.- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Bonnie" wrote in message ... I have many workbooks with several pages in them for the very first time I have a problem I have one workbook that when I open it I get two copies of it in the window when you look at it you see worksheets1200:1 worksheets1200:2 there is only one copy of this worksheet why do I get two copies when I open it? HOW do I change this to the normal one copy only? I do not what two copies I can close one copy and the other one stays open to use if someone can tell me how I set it to open two copies I would appreciated it also please tell how to get it to stop opening two copies thanks Bonnie Proud Marine Mom of LCpl Rick |
#3
|
|||
|
|||
that is what I have been doing
but this is the only workbook that is doing that do you know why just one is doing it? --=20 Bonnie Proud Marine Mom of LCpl Rick "David McRitchie" wrote in message = ... Close either copy. A second view was created under the Window menu. It allows to to view two different sheets in the smae workbook or two = or more views of same worksheet. So you could for instance look at totals = and data at the same time.- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm =20 "Bonnie" wrote in message = ... =20 I have many workbooks with several pages in them =20 for the very first time I have a problem =20 I have one workbook that when I open it I get two copies of it =20 in the window when you look at it you see =20 worksheets1200:1 worksheets1200:2 =20 there is only one copy of this worksheet why do I get two copies when I open it? =20 HOW do I change this to the normal one copy only? =20 I do not what two copies =20 I can close one copy and the other one stays open to use =20 if someone can tell me how I set it to open two copies I would appreciated it =20 also please tell how to get it to stop opening two copies =20 thanks =20 =20 Bonnie Proud Marine Mom of LCpl Rick =20 =20 =20 |
#4
|
|||
|
|||
After you close one window (Click on the X in the upper right), then save
the workbook. -- Regards, Tom Ogilvy "Bonnie" wrote in message ... that is what I have been doing but this is the only workbook that is doing that do you know why just one is doing it? -- Bonnie Proud Marine Mom of LCpl Rick "David McRitchie" wrote in message ... Close either copy. A second view was created under the Window menu. It allows to to view two different sheets in the smae workbook or two or more views of same worksheet. So you could for instance look at totals and data at the same time.- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Bonnie" wrote in message ... I have many workbooks with several pages in them for the very first time I have a problem I have one workbook that when I open it I get two copies of it in the window when you look at it you see worksheets1200:1 worksheets1200:2 there is only one copy of this worksheet why do I get two copies when I open it? HOW do I change this to the normal one copy only? I do not what two copies I can close one copy and the other one stays open to use if someone can tell me how I set it to open two copies I would appreciated it also please tell how to get it to stop opening two copies thanks Bonnie Proud Marine Mom of LCpl Rick |
#5
|
|||
|
|||
ok will do=20
--=20 Bonnie Proud Marine Mom of LCpl Rick "Tom Ogilvy" wrote in message = ... After you close one window (Click on the X in the upper right), then = save the workbook. =20 --=20 Regards, Tom Ogilvy =20 "Bonnie" wrote in message ... that is what I have been doing but this is the only workbook that is doing that =20 do you know why just one is doing it? =20 =20 --=20 Bonnie Proud Marine Mom of LCpl Rick =20 =20 =20 "David McRitchie" wrote in message ... Close either copy. A second view was created under the Window menu. It allows to to view two different sheets in the smae workbook or two = or more views of same worksheet. So you could for instance look at totals = and data at the same time.- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Bonnie" wrote in message ... I have many workbooks with several pages in them for the very first time I have a problem I have one workbook that when I open it I get two copies of it in the window when you look at it you see worksheets1200:1 worksheets1200:2 there is only one copy of this worksheet why do I get two copies when I open it? HOW do I change this to the normal one copy only? I do not what two copies I can close one copy and the other one stays open to use if someone can tell me how I set it to open two copies I would appreciated it also please tell how to get it to stop opening two copies thanks Bonnie Proud Marine Mom of LCpl Rick =20 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot copy from one workbook to another | Excel Discussion (Misc queries) | |||
Excel workbook fails to display when selecting from my documents. | Excel Worksheet Functions | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
copy a sheet in same workbook temporary block excel | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |