New Instances of Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brandon - 01 Feb 2007 19:59 GMT

We're exporting data from a 3rd party application into Excel 2002. When we
used to do this, Excel would open all of the workbooks in the same
"instance" of Excel so we could move the different worksheets between the
different workbooks. Now, when we export data, it opens a new "instance" of
Excel each time so that we cannot move the different worksheets between the
workbooks.

Is there a setting in Excel that would control this type of thing so that
when we open a new workbook, they'll all open in the same instance?

Signature

Brandon

==================
Presentations Direct - http://www.presentationsdirect.com
> Binding Machines
http://www.presentationsdirect.com/binding-machines/gbc-binding-machines.asp
> Laminators
http://www.presentationsdirect.com/laminators/gbc-laminators.asp
> Paper Shredders
http://www.presentationsdirect.com/paper-shredders/gbc-paper-shredders.asp
==================

Reply to this Message

Earl Kiosterud - 01 Feb 2007 20:14 GMT

Brandon,

Is it really opening a separate instance, or does it just appear so because there are now
separate buttons on the task bar? The latter is enabled with Tools - Options - View tab -
"Windows in taskbar." You'll still be able to see all the opened workbooks in the instance
with Window (menu bar) or switch between them with Ctrl-Tab. If it's really starting
separate instances, you'll only see the one workbook in the Window menu, and you can switch
between them with Alt-Tab.

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> We're exporting data from a 3rd party application into Excel 2002. When we used to do
> this, Excel would open all of the workbooks in the same "instance" of Excel so we could
[quoted text clipped - 4 lines]
> Is there a setting in Excel that would control this type of thing so that when we open a
> new workbook, they'll all open in the same instance?

Reply to this Message

Brandon - 01 Feb 2007 20:42 GMT

They appear to be separate instance because when we go to the "Window" menu,
only the one workbook shows up in the list (the other open workbooks do
not).

Signature

> Brandon,
>
[quoted text clipped - 14 lines]
>> Is there a setting in Excel that would control this type of thing so that
>> when we open a new workbook, they'll all open in the same instance?

Reply to this Message

Earl Kiosterud - 01 Feb 2007 23:03 GMT

Brandon,

I don't know how likely this is, but try the usual fixes. Do the stuff in "Excel acts
generally goofy" at http://www.smokeylake.com/excel/vfaq.htm

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> They appear to be separate instance because when we go to the "Window" menu, only the one
> workbook shows up in the list (the other open workbooks do not).
[quoted text clipped - 15 lines]
>>> Is there a setting in Excel that would control this type of thing so that when we open a
>>> new workbook, they'll all open in the same instance?

Reply to this Message

Joe - 01 Feb 2007 21:30 GMT

I have similar issue - in Excel 2007 - when I open one excel file, I would
like to drag it on my left screen and maximize, then open a different excel
file and drag it on my right screen and be able to see both at once. It
let's me toggle through them - or within one window I can split one screen -
but defeats having 2 monitors.

> We're exporting data from a 3rd party application into Excel 2002. When
> we used to do this, Excel would open all of the workbooks in the same
[quoted text clipped - 5 lines]
> Is there a setting in Excel that would control this type of thing so that
> when we open a new workbook, they'll all open in the same instance?

Reply to this Message

Brandon - 01 Feb 2007 21:42 GMT

A 2 monitor issue would be a different story. You WANT Excel to open in
multiple instances, whereas I DON'T WANT Excel to open in multiple
instances. Here's a link that addresses what you're referring to (I haven't
tested it myself).

http://groups.google.com/group/microsoft.public.excel/browse_thread/thread/7bdb2
0fb7595bfe5/a645c21a3be9c6be?lnk=gst&q=ignore+other+applications&rnum=1#a645c21a
3be9c6be

Signature

>I have similar issue - in Excel 2007 - when I open one excel file, I would
>like to drag it on my left screen and maximize, then open a different excel
[quoted text clipped - 11 lines]
>> Is there a setting in Excel that would control this type of thing so that
>> when we open a new workbook, they'll all open in the same instance?

Reply to this Message

Earl Kiosterud - 01 Feb 2007 21:59 GMT

Joe,

Can you not just spread one Excel window across both monitors. Then set each document
(inner) window to fill each monitor? You'll probably have to keep both the Excel (outer)
window and the document (workbook, inner) windows in the restored state (not maximized).

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

>I have similar issue - in Excel 2007 - when I open one excel file, I would like to drag it
>on my left screen and maximize, then open a different excel file and drag it on my right
[quoted text clipped - 9 lines]
>> Is there a setting in Excel that would control this type of thing so that when we open a
>> new workbook, they'll all open in the same instance?

Reply to this Message