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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-01-27T01:46:26+00:00

    Unfortunately, that only works if one HAS a personal macro book.  I don't have one and, when I go to the View menu, the "unhide" option is grayed out and not functional.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-01-26T19:31:28+00:00

    I think I have a much easier fix from a coworker...double click an excel file, that file and a blank sheet will open, on the blank worksheet, go to the View menu and unhide the personal macro book, then hide it again and close the workbook(s)...it should ask you if you want to save the personal.xlsb (so it stays hidden). Try to double click an excel file and see if it works...worked for me.

    EJ

    Was this answer helpful?

    0 comments
  3. HansV 462.7K Reputation points MVP Volunteer Moderator
    2016-01-20T21:39:16+00:00

    The idea is to move the existing Personal.xlsb out of the XLSTART folder, then create a new one in XLSTART by recording a macro, and finally move all code from the old version to the new one.

    All your personal macros should be available again, while the problem with an empty Excel window opening should be gone.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-01-20T21:11:10+00:00

    Option 1 worked but the file that was in the XLSTART folder was for personalized macro's and they don't seem to work unless they are in that folder, is that correct?

    Thanks,

    lp

    Was this answer helpful?

    0 comments
  5. Anonymous
    2016-01-19T00:29:20+00:00

    I was experiencing the same problem and here's what worked for me.

    I moved the PERSONAL.XLSB file from the XLSTART folder to my desktop and renamed it zPERSONAL.XLSB.

    I opened Excel and recorded a macro to create a new PERSONAL.XLSB file and saved it.

    I opened my previous personal macro book zPERSONAL.XLSB, then opened the Visual Basic editor and manually copied all of the modules over to the new PERSONAL.XLSB workbook.

    I re-saved PERSONAL.XLSB and my duplicate window issue has disappeared.

    Was this answer helpful?

    0 comments