Excel 2016: double-clicking on a file opens two Excel windows

Anonymous
2015-09-26T17:50:31+00:00

Since I have upgraded from Office 2013 to Office 2016 (from Office 365 Home), I get the following behavior in Excel:

If I double-click on a [shortcut to a] file, Excel starts with two Windows open:

  • one with the requested document
  • one blank window with no document loaded

Any clue?

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

50 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2015-12-15T17:49:29+00:00

    FOR THOSE WHO NEED TO KEEP YOUR OLD MACROS ### So, deleting PERSONAL.XLSB is not an option.

    I solved this problem exporting all my Macros from Excel, in my case I just copied and pasted it into Notepad++ using the Visual Basic from Developer Toolbar, closed Excel, than I moved (or delete if you want) my old PERSONAL.XLSB from "%appdata%\Microsoft\Excel\XLSTART", opened Excel again, created a new Macro so the file PERSONAL.XLSB was created again... And using Visual Basic again, pasted all my Macros back, closed Excel.

    Had to re-configure my shortcuts but more importantly, no more a second copy of Excel being opened.

    Was this answer helpful?

    0 comments
  2. HansV 462.7K Reputation points MVP Volunteer Moderator
    2015-11-13T18:49:14+00:00

    I'm afraid you'll have to live with it until Microsoft releases a bug fix. In the meantime, start Excel first, then open workbooks, either from within Excel or by double-clicking them in File Explorer.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-11-13T17:38:02+00:00

    Alas, that's not a solution: removing the files in XLSTART removes the functionality that's associated them!

    In my case (and many people's case) the PERSONAL.XLSB file is there, containing personal workbook-independent macros.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2015-11-13T15:43:04+00:00

    Great!  Option 1 worked like a charm.  Thanks so much for your suggestion, this has been driving me crazy.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2015-10-23T16:42:43+00:00

    Indeed, this seems to work.

    Haven't rebooted yet, though...

    Was this answer helpful?

    0 comments