Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
greenwellies
 
Posts: n/a
Default How do I get rid of a 2nd instance (xls:2)?

I have a spreadsheet. Whenever I open it, 2 copies open -- name.xls:1 and
name.xls:2. If I close one, both close. Driving me crazy, it is. It must
have something to do with the Window command but I do not see how to retun to
a simple life with 1 instance only.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Hans Knudsen
 
Posts: n/a
Default How do I get rid of a 2nd instance (xls:2)?

Press Window on the main menu, then Arrange and choose (for example) Horizontal. Click on the Excel icon on the xls:2 sheet and
press Close.

Hans


"greenwellies" skrev i en meddelelse
...
I have a spreadsheet. Whenever I open it, 2 copies open -- name.xls:1 and
name.xls:2. If I close one, both close. Driving me crazy, it is. It must
have something to do with the Window command but I do not see how to retun to
a simple life with 1 instance only.



  #3   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default How do I get rid of a 2nd instance (xls:2)?

had same question once; you accidently clicked on new window: just click on
2nd "X" down on top right (smaller grey - x) will give you more direct
control over which window is closed

"greenwellies" wrote:

I have a spreadsheet. Whenever I open it, 2 copies open -- name.xls:1 and
name.xls:2. If I close one, both close. Driving me crazy, it is. It must
have something to do with the Window command but I do not see how to retun to
a simple life with 1 instance only.

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I get rid of a 2nd instance (xls:2)?

It's not really two copies. It's two windows open to the same workbook.

Select the window you want to close and hit ctrl-w.

Then save the file.

(I think it's easier using ctrl-w than explaining which of the X's you should
click to close the which window.)

greenwellies wrote:

I have a spreadsheet. Whenever I open it, 2 copies open -- name.xls:1 and
name.xls:2. If I close one, both close. Driving me crazy, it is. It must
have something to do with the Window command but I do not see how to retun to
a simple life with 1 instance only.


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default How do I get rid of a 2nd instance (xls:2)?

Hi, Green, would agree there are good points for using any method.
advise some caution for example: if have two windows open for same instance
of an excel file, have noticed that (in "at-least") one case of personally
modified colors (had used formerly dark colors to add more light tones) &
sheet had gone mostly black on one of the instances. closing the wrong
window will let you save the undesired window. Where Cntrl-W does not
discern up front positive / negative logic (which window are you closing,
which are you keeping...) is more dangerous a thing to have even been
included in the software. I have already found some of the other things that
get blown away... sorry, thought you should know. (check for changes, maybe
close the 2nd instance)



"greenwellies" wrote:

I have a spreadsheet. Whenever I open it, 2 copies open -- name.xls:1 and
name.xls:2. If I close one, both close. Driving me crazy, it is. It must
have something to do with the Window command but I do not see how to retun to
a simple life with 1 instance only.

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
Getting Excel MDI/SDI/Excel Instance to behave more logically mswlogo Setting up and Configuration of Excel 2 April 23rd 23 11:43 AM
Identifying First Instance of a Value Given a Criteria carl Excel Worksheet Functions 2 April 10th 06 07:24 PM
Can I generate the excel chart with out opening the excel instance? ramkumar_cpt Charts and Charting in Excel 1 March 1st 06 05:22 PM
Find 2nd instance of a word in a range. Grumpy Grandpa Excel Worksheet Functions 8 December 5th 05 03:29 PM
Excel instance used with "Export to Microsoft Excel" option in Internet Explorer Karl Schweitzer Excel Discussion (Misc queries) 0 April 7th 05 06:17 PM


All times are GMT +1. The time now is 02:58 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"