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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2018-03-09T08:44:23+00:00

    Hi Nutmix,

    Please check the result if you only disable one of Microsoft Office Configuration Analyzer Tool and MySQL for Excel.

    If this can be fixed by disabling My SQL for Excel, since it is a third-party add-in, I would suggest contacting MySQL add-in provider to report this.

    If this can be fixed by disabling Microsoft Office Configuration Analyzer Tool or disabling both of them, I suggest post a new thread in this forum to focus on your specific situation.

    Regards,

    Joanne

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-03-08T06:39:12+00:00

    I have had the same issue for at least 6 months, and it was driving me crazy.  Option C "fixed" it at the expense of having to remove the com addins. Not really a fix, more of temporary workaround with reduced functionality.

    These are the two com addins I had to disable to fix the issue:

    1. Microsoft Office Configuration Analyzer Tool
    2. MySQL for Excel.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-02-23T08:38:39+00:00

    Hi HikingYU,

    You can try unchecking a COM add-in by the following steps by the steps in this article:

    1. Click the File tab, click Options, and then click the Add-Ins category.
    2. In the Manage box, click COM Add-ins, and then click Go. The COM Add-Ins dialog box appears.
    3. In the Add-Ins available box, clear the check box next to the add-in that you want to remove, and then click OK.

    Note    This removes the add-in from memory but keeps its name in the list of available add-ins. It does not delete the add-in from your computer.

    If the issue persists after disabling the add-in, we suggest posting a new thread in this forum and we will continue assist on your specific case.

    Regards,

    Joanne

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments