4

(Excel 2016 on Windows 10)

Suppose one or more workbooks are open, but they have been minimized. When I open another workbook, for example by double-clicking on it in Explorer, one of the minimized workbook window always restores (pops up) before the newly-opened workbook is displayed. The formerly-minimized workbook remains open and visible, behind the one I've just opened. This behavior interferes with my work, as I often have many windows (not just Excel) open at once, and switch between them frequently.

Does anybody know why this behavior exists? Excel 2007 did not work this way under Windows 7. More importantly, how can I prevent this annoying behavior?

1 Answer 1

1

This works for me:

  1. Update the following registry:

Computer\HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command (Default)

By default, should look something like: "C:\Program Files\Microsoft Office\Root\Office16\excel.exe" "%1"

Add the /e switch, eg. "C:\Program Files\Microsoft Office\Root\Office16\excel.exe" /e "%1"

  1. Restart your computer

The /e switch "Prevents the Excel startup screen from appearing and a new blank workbook from opening."

Microsoft Office Switch Reference

Similar Question Regarding Word

1
  • YES! Why is this question not more popular? The same works for Excel.CSV, that's where it was bugging me just now.
    – kiw
    Commented Feb 9 at 11:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .