To make excel open each spreadsheet in a different instance, and thus only close 
the current one when you click the "x":

change the file association stuff in windows. Go 
to explorer, choose tools, then folder options. Click the File Types 
tab. Scroll down to the XLS extension. Click the Advanced button. 
Choose "open", then click the edit button. 


At the end of the "Application used" entry, you'll probably see:   /e 
  After this, add:  "%1"   (be sure to include the quotes.) 


Then uncheck the "Use DDE" checkbox. Then click OK. (Windows re-checks 
it at some point for some reason, but it still works) 


OK your way out of the file types dialog. 


Now when you double-click a spreadsheet, it will open it in a new 
instance of Excel. 


Hope it helps! 


Dave 









On Thursday, December 18, 2003 at 1:07 pm, Shawn wrote:

>I don't know! I would LOVE to be able to only close the current workbook, like with 

>a word document, and NOT close all other excel sheets.  I've lost so much data due 

>to this Microsoft FLAW... So the question still stands:

>

>Is there a way to set excel to open workbooks in different instances, so that when 

>you click on the Program 'X', it only closes the current workbook like with Word?

>

>
 

• Reply or follow-up to this message

• Search this forum
• Start a new thread on a different subject

• Report abuse of the forum