Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 19th 07, 03:46 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 4
Default Open separate instances of excel

When I open an excel document, excel opens the document in the same instance
of excel. When you close excel, it closes all open workbooks. I would like
to be able to close the instance of excel that I am working in (by hitting
the top X) and continue to work on seperate excel documents that are open.
This works in Word, but not in excel. Any ideas on how to fix this one?
Thank you!

  #2   Report Post  
Old April 20th 07, 06:10 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,942
Default Open separate instances of excel

hi,
in excel, there are 2 X's. the big red X closes excel and all worksheets.
the small black x under the big red X closes the active work sheet only and
leaves the rest of the worksheets open.
Regards
FSt1

"Waterboy" wrote:

When I open an excel document, excel opens the document in the same instance
of excel. When you close excel, it closes all open workbooks. I would like
to be able to close the instance of excel that I am working in (by hitting
the top X) and continue to work on seperate excel documents that are open.
This works in Word, but not in excel. Any ideas on how to fix this one?
Thank you!

  #3   Report Post  
Old April 20th 07, 04:46 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 96
Default Open separate instances of excel

You can do that but you will have to open every single Excel file that you
open in a separate instance of Excel.
Example, you open up Excel and then open up Book1. If now you want to open
up Book2 you can NOT just click on file / open. You will have to start Excel
again by either following Start / Programs / Excel or double-clicking the
Excel icon on your desktop, etc and then open up Book2. Now you have 2
separate instances of Excel, each with one workbook open. When you close the
Excel instance that has Book1 open, the instance with Book2 open remains.

Not sure why you want to do this though (unless you have some macro
automation with other Microsoft products ex, Access). You can just close the
individual workbooks in Excel and still leave Excel up and running with
whatever other workbooks are already open in the same instance.

"Waterboy" wrote:

When I open an excel document, excel opens the document in the same instance
of excel. When you close excel, it closes all open workbooks. I would like
to be able to close the instance of excel that I am working in (by hitting
the top X) and continue to work on seperate excel documents that are open.
This works in Word, but not in excel. Any ideas on how to fix this one?
Thank you!

  #4   Report Post  
Old April 20th 07, 05:28 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 4
Default Open separate instances of excel

(I posted the same reply to FSt1)
I am in IT support and a user asked me about that. I know there are the two
X's but for some reason she likes to have separate instances running so she
can click the top X and only close the active workbook. I just thought there
might be a setting in excel or in Microsoft that would allow you to do this.
I will let her know that the correct way to do this is to open excel
seperately and then open the file(s) of interest. Thank you very much for
your help.



"William Horton" wrote:

You can do that but you will have to open every single Excel file that you
open in a separate instance of Excel.
Example, you open up Excel and then open up Book1. If now you want to open
up Book2 you can NOT just click on file / open. You will have to start Excel
again by either following Start / Programs / Excel or double-clicking the
Excel icon on your desktop, etc and then open up Book2. Now you have 2
separate instances of Excel, each with one workbook open. When you close the
Excel instance that has Book1 open, the instance with Book2 open remains.

Not sure why you want to do this though (unless you have some macro
automation with other Microsoft products ex, Access). You can just close the
individual workbooks in Excel and still leave Excel up and running with
whatever other workbooks are already open in the same instance.

"Waterboy" wrote:

When I open an excel document, excel opens the document in the same instance
of excel. When you close excel, it closes all open workbooks. I would like
to be able to close the instance of excel that I am working in (by hitting
the top X) and continue to work on seperate excel documents that are open.
This works in Word, but not in excel. Any ideas on how to fix this one?
Thank you!

  #5   Report Post  
Old April 20th 07, 05:28 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 4
Default Open separate instances of excel

I am in IT support and a user asked me about that. I know there are the two
X's but for some reason she likes to have separate instances running so she
can click the top X and only close the active workbook. I just thought there
might be a setting in excel or in Microsoft that would allow you to do this.
I will let her know that the correct way to do this is to open excel
seperately and then open the file(s) of interest. Thank you very much for
your help.

"FSt1" wrote:

hi,
in excel, there are 2 X's. the big red X closes excel and all worksheets.
the small black x under the big red X closes the active work sheet only and
leaves the rest of the worksheets open.
Regards
FSt1

"Waterboy" wrote:

When I open an excel document, excel opens the document in the same instance
of excel. When you close excel, it closes all open workbooks. I would like
to be able to close the instance of excel that I am working in (by hitting
the top X) and continue to work on seperate excel documents that are open.
This works in Word, but not in excel. Any ideas on how to fix this one?
Thank you!



  #6   Report Post  
Old April 25th 07, 02:58 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 1
Default Open separate instances of excel

I had the opposite problem. try going to "Tools"-"Options" on the view tab
check "Windows in Task Bar"

"Waterboy" wrote:

When I open an excel document, excel opens the document in the same instance
of excel. When you close excel, it closes all open workbooks. I would like
to be able to close the instance of excel that I am working in (by hitting
the top X) and continue to work on seperate excel documents that are open.
This works in Word, but not in excel. Any ideas on how to fix this one?
Thank you!



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
Open Separate Excel Files in Separate Windows JTWood Excel Discussion (Misc queries) 3 May 7th 06 10:18 PM
How do I create two separate instances of Excel? Flowermountain Excel Discussion (Misc queries) 1 February 1st 06 04:48 PM
Open Excel files in separate sessions, not just separate windows? Bob at Dexia Design Excel Discussion (Misc queries) 1 October 18th 05 05:46 PM
Opening two separate instances of Excel Ron Bishop Excel Discussion (Misc queries) 2 August 4th 05 05:30 PM
Excel opening files in separate instances -why? Gazza Excel Discussion (Misc queries) 3 June 8th 05 02:01 AM


All times are GMT +1. The time now is 02:32 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017