Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open additional document in a new Excel window
Is there any way to open multiple workbooks in Excel 2000 and have
each workbook open in a new *Excel window*? MS Word 2000 does this, by default, i.e., each new Word document file opened appears in a new Word window. Will newer versions of Excel do this? I have two monitors running, and when each document file opens in a new window, it is possible/easy to put one document on each monitor, and have both visible in large size at the same time, and adjust each of the windows individually. One can "sort of" do this by spreading the one Excel window across both monitors, and then reducing each file from full screen mode (or whatever is called for a document rather than a window) but that is not convenient since it spreads the Excel window borders with the toolbars, etc. across both monitors, and my two monitors are not the same size/resolution. Hence I need to adjust the window size on each monitor. TIA Fred Holmes |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open additional document in a new Excel window
Check out this link...
http://www.cpearson.com/excel/MultipleMonitors.aspx -- HTH... Jim Thomlinson "Fred Holmes" wrote: Is there any way to open multiple workbooks in Excel 2000 and have each workbook open in a new *Excel window*? MS Word 2000 does this, by default, i.e., each new Word document file opened appears in a new Word window. Will newer versions of Excel do this? I have two monitors running, and when each document file opens in a new window, it is possible/easy to put one document on each monitor, and have both visible in large size at the same time, and adjust each of the windows individually. One can "sort of" do this by spreading the one Excel window across both monitors, and then reducing each file from full screen mode (or whatever is called for a document rather than a window) but that is not convenient since it spreads the Excel window borders with the toolbars, etc. across both monitors, and my two monitors are not the same size/resolution. Hence I need to adjust the window size on each monitor. TIA Fred Holmes |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open additional document in a new Excel window
Hi,
One way is to open a new instance of Excel, then open the file from that copy. Fair warning, you are using more memory when you do this which may become a problem if you try to open too many files. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Fred Holmes" wrote: Is there any way to open multiple workbooks in Excel 2000 and have each workbook open in a new *Excel window*? MS Word 2000 does this, by default, i.e., each new Word document file opened appears in a new Word window. Will newer versions of Excel do this? I have two monitors running, and when each document file opens in a new window, it is possible/easy to put one document on each monitor, and have both visible in large size at the same time, and adjust each of the windows individually. One can "sort of" do this by spreading the one Excel window across both monitors, and then reducing each file from full screen mode (or whatever is called for a document rather than a window) but that is not convenient since it spreads the Excel window borders with the toolbars, etc. across both monitors, and my two monitors are not the same size/resolution. Hence I need to adjust the window size on each monitor. TIA Fred Holmes |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open additional document in a new Excel window
Not a useful link. It has the solution that I have already found to
be less than satisfactory. Chip Pearson is using a configuration where the multiple monitors are all the same. I'd do that too if I could find the physical/room desktop space to do it. I can't fit two 22" monitors side-by-side on my desk. If Word does what I want, why not Excel? I know, two differnt teams developed the two different applications, and came to two different conclusions about what the consumer would like. Such is life. Opening separate instances of the application (Excel) would be much more convenient. Many thanks for all you folks do. I know you can't create what isn't provided for. Fred Holmes On Wed, 3 Jun 2009 07:08:07 -0700, Jim Thomlinson wrote: Check out this link... http://www.cpearson.com/excel/MultipleMonitors.aspx -- HTH... Jim Thomlinson "Fred Holmes" wrote: Is there any way to open multiple workbooks in Excel 2000 and have each workbook open in a new *Excel window*? MS Word 2000 does this, by default, i.e., each new Word document file opened appears in a new Word window. Will newer versions of Excel do this? I have two monitors running, and when each document file opens in a new window, it is possible/easy to put one document on each monitor, and have both visible in large size at the same time, and adjust each of the windows individually. One can "sort of" do this by spreading the one Excel window across both monitors, and then reducing each file from full screen mode (or whatever is called for a document rather than a window) but that is not convenient since it spreads the Excel window borders with the toolbars, etc. across both monitors, and my two monitors are not the same size/resolution. Hence I need to adjust the window size on each monitor. TIA Fred Holmes |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open additional document in a new Excel window
If this works as advertised, it's a definite "yes," but I don't find
or know what you mean by the "Yes button." I guess I should have thought of trying this myself. That it's not necessary in MS Word didn't lead me to think of it. A real problem with the method suggested by Chip Pearson is that if you simply close Excel, then work on other workbooks with the Excel Window limited to one monitor, and then open (by double-clicking) one of the workbooks that had been displayed on the additional monitor, you get a situation where the workbook is displayed "off screen" and you have to go through a time-consuming process to bring it back on-screen. The workbook window remembers its "restored" configuration, which is on my right-hand monitor, but the Excel window doesen't extend there right now, and the "full" button isn't visible. I have a full bank of memory = 4 GB, with max usage of 3 GB under a 32-bit OS. Workbooks are generally small, 100 KB or so. Many thanks for your help. Fred Holmes On Wed, 3 Jun 2009 07:33:05 -0700, Shane Devenshire wrote: Hi, One way is to open a new instance of Excel, then open the file from that copy. Fair warning, you are using more memory when you do this which may become a problem if you try to open too many files. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Fred Holmes" wrote: Is there any way to open multiple workbooks in Excel 2000 and have each workbook open in a new *Excel window*? MS Word 2000 does this, by default, i.e., each new Word document file opened appears in a new Word window. Will newer versions of Excel do this? I have two monitors running, and when each document file opens in a new window, it is possible/easy to put one document on each monitor, and have both visible in large size at the same time, and adjust each of the windows individually. One can "sort of" do this by spreading the one Excel window across both monitors, and then reducing each file from full screen mode (or whatever is called for a document rather than a window) but that is not convenient since it spreads the Excel window borders with the toolbars, etc. across both monitors, and my two monitors are not the same size/resolution. Hence I need to adjust the window size on each monitor. TIA Fred Holmes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get Excel to open a document in a new Window ? NEW QUEST | Excel Discussion (Misc queries) | |||
DOCUMENT PREVIEW IN THE OPEN WINDOW? | New Users to Excel | |||
How do I get Excel to open each document in a new window? | Excel Discussion (Misc queries) | |||
Saving an Excel document after moving additional worksheets to it | New Users to Excel | |||
How do I set Excel to auto open a document into a new Window even. | Excel Worksheet Functions |