Help!

Open separate instances of excel

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup RSS
Next:  Unable to open some 2003 files in Excel 2007  
Author Message
Waterboy
External


Since: Apr 21, 2006
Posts: 5



PostPosted: Thu Apr 19, 2007 11:46 am    Post subject: Open separate instances of excel
Archived from groups: microsoft>public>excel>setup (more info?)

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!
Back to top
FSt1
External


Since: Mar 03, 2006
Posts: 441



PostPosted: Fri Apr 20, 2007 2:10 am    Post subject: RE: Open separate instances of excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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!
Back to top
William Horton
External


Since: Apr 21, 2006
Posts: 86



PostPosted: Fri Apr 20, 2007 12:46 pm    Post subject: RE: Open separate instances of excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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!
Back to top
Waterboy
External


Since: Apr 21, 2006
Posts: 5



PostPosted: Fri Apr 20, 2007 1:28 pm    Post subject: RE: Open separate instances of excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

(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!
Back to top
Waterboy
External


Since: Apr 21, 2006
Posts: 5



PostPosted: Fri Apr 20, 2007 1:28 pm    Post subject: RE: Open separate instances of excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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!
Back to top
Dan H
External


Since: Apr 25, 2007
Posts: 1



PostPosted: Wed Apr 25, 2007 10:58 am    Post subject: RE: Open separate instances of excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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!
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum