#1   Report Post  
Beans
 
Posts: n/a
Default 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
----------------------------------------------

  #2   Report Post  
Max
 
Posts: n/a
Default

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
----------------------------------------------



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? Bill O'Neal Excel Worksheet Functions 8 August 14th 09 11:36 PM
how do i look through worksheets in a workbook to find duplicate Connie Excel Worksheet Functions 1 June 25th 05 05:10 PM
Unprotect Workbook Kent Excel Discussion (Misc queries) 1 February 4th 05 01:07 AM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 02:02 PM
how can I duplicate or copy a workbook then divide selected cells. macros excel... duplication and calculat Excel Discussion (Misc queries) 1 November 29th 04 03:16 PM


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"