Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I delete one of the following[workbook]:1 and [workbook]:2

When I open one particular workbook I get two copies labeled [workbook
name]:1 and [workbook name]:2. Whwn I make changes to one, the second one is
also updated. How do I delete one of the these versions of the same workbook?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default How do I delete one of the following[workbook]:1 and [workbook]:2

This will have been set up with two windows open to the same file. You
can just close one window (using the X in the top right corner of the
file window, NOT the Excel window), and then save the file. Next time
you open it there will only be one window to the file.

Hope this helps.

Pete

On Oct 23, 4:13*pm, Boston Jerry <Boston
wrote:
When I open one particular workbook I get two copies labeled [workbook
name]:1 and [workbook name]:2. *Whwn I make changes to one, the second one is
also updated. *How do I delete one of the these versions of the same workbook?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How do I delete one of the following[workbook]:1 and [workbook]:2

They are not versions of the same workbook, just two windows.

Close one of the windows and save the workbook.

You get these in the first place from going to WindowNew Window


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 08:13:01 -0700, Boston Jerry <Boston
wrote:

When I open one particular workbook I get two copies labeled [workbook
name]:1 and [workbook name]:2. Whwn I make changes to one, the second one is
also updated. How do I delete one of the these versions of the same workbook?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do I delete one of the following[workbook]:1 and [workbook]:2

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

Then save your workbook--or you'll have to do it again the next time you open
it.

Boston Jerry wrote:

When I open one particular workbook I get two copies labeled [workbook
name]:1 and [workbook name]:2. Whwn I make changes to one, the second one is
also updated. How do I delete one of the these versions of the same workbook?


--

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
Delete duplicates on 2nd workbook Dude Excel Discussion (Misc queries) 4 July 21st 09 11:34 PM
How can I delete all matches in a workbook? LiveUser Excel Worksheet Functions 4 January 18th 08 08:55 PM
How to Delete a Range in Closed Workbook (to Replace Delete Query) [email protected] Excel Discussion (Misc queries) 1 March 8th 06 10:10 AM
in workbook, where is delete worksheet Teressa Excel Worksheet Functions 5 January 19th 06 11:46 PM
how do you delete a workbook Bob Excel Discussion (Misc queries) 2 October 3rd 05 12:18 AM


All times are GMT +1. The time now is 07:18 AM.

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"