Multiple instances of Excel

[Spencer.Sadkin]

I know I can run multiple instances of excel (I do it all the time to
compare workbooks) but what I would like to do is "pop-out" a workbook
from the instance of excel so that i can have one workbook on my left
screen and one on my right but i can still link by clicking in each.
Any ideas, or utilities?

Thanks.

 

[PCLIVE]

I'm assuming you have two monitors. Are you able to have Excel displayed on
either monitor as desired? When you make it full screen, is it only on that
monitor and not across both?

If yes, then there are two ways to possibly do this. Stretch the Excel
window across both monitors and then go to Window | Arrange and select the
desired option.

However, what I think you want is pretty much what you already said. You
need to have two instances of Excell open. This is not done by opening
second Excel workbook. You have to just open Excel by double-clicking on
the Excel icon from the programs menu. Again, this is not done by opening
another .xls file.

Then you should be able drag one instance to one monitor and another
instance to the other. I do this all the time.

HTH,
Paul

 

[Tim Zych]

Perhaps my Workbook Compare utility will help you.

www.higherdata.com


--
Regards,

Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility

 

[Spencer.Sadkin]

Havent looked at the workbook compare utility, i will do that in a
second. PCLive, your first Idea is actually much closer than your
second. If you open two sepearte instances of excel you can not
easily reference a cell from the other instance. I want to be able
type = and then click in the other window to reference the cell. And
yes, I do have two monitors and can drag excel any which way I
please.

Thanks again,

 

[Spencer.Sadkin]

Tim, nifty utility, but not what im looking for. Thanks.

 

[Tim Zych]

I'm curious..what are you doing? Is there a feature missing in the utility?

--
Regards,
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility

 

[Spencer.Sadkin]

No, im not comparing changes between two of the same files (which is
what your addin seems to do) I am looking at two sepearte spreadsheets
and referencing cells between them. In fact if it is able to be done
( I hightly doubt it) a feature that would be awesome is to have the
same exact workbook open on each monitor. And then be on different
sheets in the workbook so that you can reference a cell from a
previous sheet without having to switch tabs.

Make sense?

 

[PCLIVE]

Ahh,

I see what you mean now. I'm not sure if that is possible with multiple
instances. Hopefully stretching the window across both screens will be
adequate...unless someone else has an idea

Good luck,
Paul

 

[Spencer.Sadkin]

I doubt earlier versions have it, but excel 2007 actually has a cool
feature where you can open a "view" of the current workbook so
stretching one app across two screens makes what i described doable,
thats probably my best bet, but it would still be great to actually be
able to resize the window to fit automatically.

 

[PCLIVE]

Here's another idea. It sounds like you have two instances of the same
workbook open and you what two be able to compare two different tabs without
having to switch back and forth. Using what I mentioned before about
stretching the window across both monitors, click on Window | New Window.
Now you have two views of the same workbook and you can change tabs
separately. It will also let you reference the other sheet the way you
mentioned with the exception of an extra click due to having to click ones
to activate the other view.
If you are using two different workbooks, it should function in the same
way.

HTH,
Paul

 

[Tim Zych]

I am looking at two sepearte spreadsheets

and referencing cells between them.

It does that. That's the most common comparison. Select the two workbooks
from the main setup.

It also can compare sheets within the same workbook, if you need. For that
matter, columns within a single sheet (in the same workbook) are comparable.
It's extremely versatile.

Basically, any worksheet is comparable to any other worksheet, whether it's
in the same workbook of a different one. Any column can be mapped to any
other column, whether it's in the same sheet or another.

--
Regards,

Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility

 

[Spencer.Sadkin]

Yup, thats what I had just figured out, didnt realize older versions
had it too. Still dont like the stretching across two screens but
hey, nothing in the world is perfect. Thanks again.