ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Duplicate workbook (https://www.excelbanter.com/excel-discussion-misc-queries/47961-duplicate-workbook.html)

Beans

Duplicate workbook
 
I have a workbook, that, when openned, opens a duplicate copy. The
sheets are given the following naming convention:
Workbook.xls:1 and workbook.xls:2.
All changes done in one goes to the other.

What was activated to enable this, and how do you turn this off

TIA

----------------------------------------------
Posted with NewsLeecher v3.0 Beta 3
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------


Max

Its just 2 windows. Click Window Arrange Tiled (say) OK
This will arrange the 2 windows side-by-side. Then just close one of the 2
by clicking the "x" at the top right corner, then click to maximise the
remaining window.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Beans" wrote in message
...
I have a workbook, that, when openned, opens a duplicate copy. The
sheets are given the following naming convention:
Workbook.xls:1 and workbook.xls:2.
All changes done in one goes to the other.

What was activated to enable this, and how do you turn this off

TIA

----------------------------------------------
Posted with NewsLeecher v3.0 Beta 3
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------




Dave Peterson

You actually have two windows into the same workbook open
(caused by window|new window)

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

remember to save the workbook--or you'll have to do it again.

Beans wrote:

I have a workbook, that, when openned, opens a duplicate copy. The
sheets are given the following naming convention:
Workbook.xls:1 and workbook.xls:2.
All changes done in one goes to the other.

What was activated to enable this, and how do you turn this off

TIA

----------------------------------------------
Posted with NewsLeecher v3.0 Beta 3
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------


--

Dave Peterson


All times are GMT +1. The time now is 08:56 PM.

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