WeThotUWasAToad
asked on
Open an Excel workbook without restoring (un-minimizing) another one
Hello,
When one or more Excel (2013) workbooks are running but minimized and a new or existing workbook is opened, is there any way to prevent an already-running workbook from:
a) appearing (un-minimizing) with it?
b) defining the location and dimensions of the newly-opened workbook?
For example, suppose you have the following workbooks:
A.xls
B.xls
C.xls
D.xls
and suppose that the first three are currently running but minimized. (Oh, and assume that they were opened in their respective order: A.xls then B.xls then C.xls.)
Now, opening the 4th workbook (D.xls) (or a new workbook) seems to require that:
• C.xls first be un-minimized and
• D.xls acquire the same dimensions as C.xls and
• D.xls be positioned just down and to the right (cascading) of it.
Does anyone see a process in their Excel app which is different than that and if so, can you say where the settings can be found?
I seem to recall that in older versions of Excel, the position and dimensions of a new Excel workbook were determined by the last workbook that was closed — the same as is still the case for Notepad. That was much better imo.
Thanks
When one or more Excel (2013) workbooks are running but minimized and a new or existing workbook is opened, is there any way to prevent an already-running workbook from:
a) appearing (un-minimizing) with it?
b) defining the location and dimensions of the newly-opened workbook?
For example, suppose you have the following workbooks:
A.xls
B.xls
C.xls
D.xls
and suppose that the first three are currently running but minimized. (Oh, and assume that they were opened in their respective order: A.xls then B.xls then C.xls.)
Now, opening the 4th workbook (D.xls) (or a new workbook) seems to require that:
• C.xls first be un-minimized and
• D.xls acquire the same dimensions as C.xls and
• D.xls be positioned just down and to the right (cascading) of it.
Does anyone see a process in their Excel app which is different than that and if so, can you say where the settings can be found?
I seem to recall that in older versions of Excel, the position and dimensions of a new Excel workbook were determined by the last workbook that was closed — the same as is still the case for Notepad. That was much better imo.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Please correct me if I'm wrong but I believe each of you is referring to an older version of Excel. In the first sentence of my post I specified that I was referring to Excel 2013:
"When one or more Excel (2013) workbooks are running…"
And as pointed out in this LifeHacker article:
"…every spreadsheet in Excel 2013 opens in a separate instance of the program."
Thanks