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
    2018-08-16T00:15:27+00:00

    To the extent this is caused by MySQL for Excel, there is a bug report thread available

    here.  Seems to be an issue w quite a few users.  Maybe some additional reports will get this addressed.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-05-28T18:21:37+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

    This was the case. MySQL plugin causing Excel to open a blank sheet in my PC.

    Was this answer helpful?

    1 person found 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