2016 Excel opens two windows when opening file

Anonymous
2017-10-24T21:36:41+00:00

When I open an Excel file from Explorer by clicking on the file, two windows open: the spreadsheet AND a second Excel window, no spreadsheet open--just a blank Excel Window.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2018-01-19T18:57:25+00:00

Your 'c' option fixed this issue for me.   I recently installed MySQL on my laptop and that was the COM Add-in that triggered a secondary 'blank' spreadsheet.   As soon as I unchecked 'MySQL for Excel' under COM Add-ins, I only open the spreadsheet I desired.

Thanks

Was this answer helpful?

300+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2018-07-04T03:07:13+00:00

I disabled the solver add-ins and no more second sheet (blank) : options --> Add-ins --> Manage Excel Add-ins  (bottom) --> Go...

Unchecked Solver Add-in box and it worked.

I may need later to re-enable the Solver Add-in but at least I have a way to disable that second annoying window. Hope this helps.

Was this answer helpful?

80+ people found this answer helpful.
0 comments

51 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-09-06T15:57:43+00:00

    I am a developer of an Excel add-in, and this 'second grey window' problem appeared about a year ago as part of an Office update.

    Because Microsoft has a habit of introducing as many (or more) bugs than fixes, we have a habit of keeping some development computers around that don't accept automatic Office updates.

    On Office 365 version 16.0.4429.1024, our add-in works correctly. (no second grey window)

    On the most recent version of Office 365, launching our add-in causes a second grey window to be launched.

    Exact same add-in; it is Microsoft Excel that changed.

    For obvious reasons, advising our customers to 'disable our add-in' is not an acceptable solution.

    Is it possible for Microsoft to isolate what changed in Excel?

    and then either:

    1. Fix it (to work the way Excel has always worked in the past with add-ins)

    or 2) At least let us developers know what changed, and how we can re-write our applications to work with Excel's (currently undocumented) revised code?

    Dean Ziegler

    Systems2win

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-07-02T23:29:08+00:00

    Hi Dionna,

    Please try the followings to see the result:

    a.Disable preview pane in File Explorer (open File Explorer, click View tab and make sure Preview Pane is not enabled).

    b.Navigate to C:\Users*<username>\AppData\Roaming\Microsoft\Excel\XLSTART* check if there is any file and move it to other location.

    c.Open Excel and go to File tab->Options->Add-ins, Set "Manage" to "COM Add-ins" and click Go, Write down which add-ins are selected, uncheck them all, choose OK.

    Let us know if above work for you.

    Regards,

    Joanne

    Hi Joanna,

    Option b worked for me.  Thank you!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2018-10-28T09:28:01+00:00

    Thanks for this solution. In my case the add-in I needed to disable was "MySQL for Excel" so it looks like if anyone hits such issue they should try disabling any add-in and find the right one.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments