ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   getting rid of the second wookbook version (https://www.excelbanter.com/excel-discussion-misc-queries/252586-getting-rid-second-wookbook-version.html)

PilotsWest

getting rid of the second wookbook version
 
Help, I did a split screen to view two workbooks and some way ended up with a
duplicate wookbook. However, it is not a seperate file. When I open the
file it lists both versions; ie. workbook.xls:1 AND workbook.xls:2.

How do I get rid of the second version ( it is the same file I assume) ?

Thank you

Don

Bernard Liengme[_2_]

getting rid of the second wookbook version
 
You do not tell us what Excel version.
Use Windows or View to display both in tiled form
Close the :2 version
Save the file
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"PilotsWest" wrote in message
...
Help, I did a split screen to view two workbooks and some way ended up
with a
duplicate wookbook. However, it is not a seperate file. When I open the
file it lists both versions; ie. workbook.xls:1 AND workbook.xls:2.

How do I get rid of the second version ( it is the same file I assume) ?

Thank you

Don



Bob Umlas[_3_]

getting rid of the second wookbook version
 
close either with the "X" in the upper right. Save the wb.
Bob Umlas
Excel MVP

"PilotsWest" wrote in message
...
Help, I did a split screen to view two workbooks and some way ended up
with a
duplicate wookbook. However, it is not a seperate file. When I open the
file it lists both versions; ie. workbook.xls:1 AND workbook.xls:2.

How do I get rid of the second version ( it is the same file I assume) ?

Thank you

Don



PilotsWest

getting rid of the second wookbook version
 
Thank you so much for your help. I did as you said and now have only one
version.

Don

"Bernard Liengme" wrote:

You do not tell us what Excel version.
Use Windows or View to display both in tiled form
Close the :2 version
Save the file
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"PilotsWest" wrote in message
...
Help, I did a split screen to view two workbooks and some way ended up
with a
duplicate wookbook. However, it is not a seperate file. When I open the
file it lists both versions; ie. workbook.xls:1 AND workbook.xls:2.

How do I get rid of the second version ( it is the same file I assume) ?

Thank you

Don


.



All times are GMT +1. The time now is 02:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com