Excel - How to open Two copies of Excel under Win7

Asked By Roger on 24-Dec-09 01:43 PM
I have two different workbooks I would like to view at the same time. I would
also like to copy & paste cels from one spreadsheet to the other.

Under Winxp and earlier I could have two instances of Excel open at the same
time. Win-7 seems to prevent this.

The answers previously given do not apply to Win-7 as I cannot find the
options such as TOOLS so I can make changes.

trip_to_tokyo replied to Roger on 24-Dec-09 01:57 PM
Hi Roger, you can have 2 instances of EXCEL running under Windows 7: I have
just tested it and it works OK and you can do exactly what you want to do.

Please hit Yes if my comments have helped.

trip_to_tokyo replied to Roger on 24-Dec-09 02:01 PM
If you go to the task bar (at the bottom of the screen) once you have opened
the 2 instances of EXCEL you will see them both in the task bar (one instance
will be slightly to the right of the first one).

Please hit yes if my comments have helped.

trip_to_tokyo replied to Roger on 24-Dec-09 02:09 PM
You might like to look at the brief video:-

Gord Dibben replied to trip_to_tokyo on 24-Dec-09 02:34 PM
Just curious about "do exactly what you want to do"

In earlier version when you had two instances of Excel running you could not
copy and paste formulas from one instance to the other.

Are you saying you now do this with Windows 7?

I would have thought the copy/paste would be Excel dependent, not OS

Gord Dibben  MS Excel MVP
Gary Keramidas replied to Roger on 25-Dec-09 02:35 AM
i have it pinned to the taskbar. if i click it once, an instance opens. if i
then right click and choose microsoft excel from the menu, another instance

-- or, you can just hold the shift key when you click the taskbar icon and
another instance will open.

Gary Keramidas
Excel 2003
TopQuark replied to Gary Keramidas on 26-Dec-09 11:52 AM
THIS is is the correct response.  One can also set the task bar such that
the open applications are not stacked up under the icon that launches them.
In other words, one can set it up to appear on the task bar in the
'classical' 'legacy' manner, where each open application uses up a task bar
area of its own.  I like it stacked, and once the paradigm is learned and
familiar, it is quite intuitive and practical.