Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
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 -- wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
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 wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
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, |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
Tim, nifty utility, but not what im looking for. Thanks.
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
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 wrote in message ... Tim, nifty utility, but not what im looking for. Thanks. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
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? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
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 -- wrote in message ... 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, |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
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. |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
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 -- wrote in message ... 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? |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
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 wrote in message ... 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? |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple instances of Excel
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple instances of Excel (Multiple workbooks) | Setting up and Configuration of Excel | |||
Multiple Instances of EXCEL.EXE | Excel Discussion (Misc queries) | |||
Multiple Instances of Excel | Excel Discussion (Misc queries) | |||
Multiple instances of Excel | Excel Discussion (Misc queries) | |||
Multiple instances of Excel and VB | Excel Programming |