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 No 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 No 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 No comments

51 additional answers

Sort by: Most helpful
  1. Anonymous
    2019-08-31T01:13:01+00:00

    This for the most part worked for me; however, I had to recreate the PERSONAL.XLSB file that's in %appdata%/Microsoft/Excel/XLSTART.  I tried to simply copy it out-and-back but the problem returned when I did that...apparently the file was corrupted. 

    So my approach was to:

    open Excel,

    open Developer/Visual Basic,

    navigate to VBAProject (PERSONAL.XLSB)

    open Modules/module1

    copy my macros to a Notepad file

    close Excel

    move PERSONAL.XLSB out of XLSTART

    open Excel

    create one macro (choose "Store macro in: Personal Macro Workbook)

    open Visual Basic module1 again

    delete the macro I just created

    paste the macros I saved from the Notepad backup into Module1

    close Excel

    And now I only get one instance opened.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-07-10T21:40:08+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

    thank you both...option "C" was the fix.

    Make It a Great Day!

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-06-27T13:58:04+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.

    Thank, it's work for me. 

    great job.

    Was this answer helpful?

    0 comments No comments