ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Open separate instances of excel (https://www.excelbanter.com/setting-up-configuration-excel/139598-open-separate-instances-excel.html)

waterboy

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!

FSt1

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!


William Horton

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!


waterboy

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!


waterboy

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!


Dan H[_2_]

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!



All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com