Link to home
Start Free TrialLog in
Avatar of WeThotUWasAToad
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
SOLUTION
Avatar of Faustulus
Faustulus
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of WeThotUWasAToad
WeThotUWasAToad

ASKER

I appreciate the responses and I apologize for taking so long to reply.

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