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:
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.