How can I stop Excel from opening a second blank window when opening a file from Explorer?

Question

When I open an Excel file from Windows Explorer, I always get a second Excel window as well. Annoyingly, when I close it, it doesn't close, but the other window does!

This seems to be a common issue:

• Excel 2013 starts up with blank screen when opened from explorer
• Excel 2013 opens blank grey screen along with original workbook.
• Excel Opens Two Instances of File - One Blank?
• Excel 2013 Issue - Opening a worksheet, opens a new blank worksheet too

How can I stop this second window appearing?

Answer 1

This can occur due to corruption in a personal macro workbook (%appData%\Microsoft\Excel\XLSTART\), and removing PERSONAL.XLSB from this folder caused the problem to go away.

I had to export each of my macro modules to another folder, then after removing PERSONAL.XLSB, record a new macro stored in my "Personal Macro Workbook" (which recreated PERSONAL.XLSB), then on the Developer toolbar, click "Visual Basic" and import the macro modules again.

All the shortcut keys and descriptions were maintained, but more importantly, I didn't get a second copy of Excel opening every time I opened a worksheet from Explorer.

Answer 2

My extra window turned out to be a problem with add-ins. In Excel 2016, here's how to fix that:

• Open Excel.
• Go to File > Options.
• Click on Add-ins.
• Look at the Active Application Add-ins (so alliterative!)
• At the bottom of the dialog, in Manage, set the dropdown to COM Add-ins and click Go...
• Uncheck the things you don't need.

In my case, there were three COM add-ins active:

• MySQL For Excel
• DriveForOffice [Google Drive add-in]
• Microsoft Excel Code Compatibility Inspector

I left DriveForOffice but disabled the other two, and my extra window stopped showing up.

Answer 3

I had the exact same problem in Excel 2015 for quite a while, and when I hid the Personal.xlsb workbook, a blank page would open instead and I couldn't close that one without closing the file I actually wanted open.

But I finally found a solution! My problem was that I had a Personal.xlsb file in an alternate location, and for some reason a search of the C drive wasn't returning a match for that file name. My location was the same one that Amber mentioned above, but I wanted to share how I found it in case someone else has a different location.

The solution is to find the real location of the Personal.xlsb file so you can delete it. To do that, open excel and switch to the Personal.xlsb file. Now select the "File" tab on the top left which will load an "Info" page. On the right side of the information on that page there is information such as "Properties, Related Dates, Related People, and Related Documents." Directly under Related Documents is a hyperlink that says "Open File Location." Click this hyperlink and excel will open the true location of the Personal.xlsb file regardless of where your particular installation has placed it.

Now close Excel, delete the Personal.xlsb file, and reopen Excel. It should open only the file you want and a second window will no longer appear. From this point on, I expect other tips online about creating/deleting/showing/hiding the Personal.xlsb file will work as expected. But I have left it deleted and Excel is finally loading as I expect.

Answer 4

I had this issue as well. Thought it might be related to my PERSONAL.xlsb file like so many mentioned. However, it had always been successfully hidden up until recently.

I went to the XLSTART folder to see if my personal workbook was indeed in the wrong place. It was there so I tried deleting and recreating it to no avail (just a big pain in my butt with the amount of macros I have).

I went back to the XLSTART folder and saw there was also an add-in file, something I had to install for work. I deleted this file and restarted Excel - no extra window! PERSONAL.xlsb stays hidden too. Not that this is everyone's issue but it was mine

Answer 5

I had the same problem because I had created macros, which saves in PERSONAL.xlsb located in C:\Users\ username \AppData\Roaming\Microsoft\Excel\XLSTART You can just open from this location go to the View tab and select Hide. From now on when you open a file this will no longer open as well, but will still allow use of, for example, macros created that you'd want to use in multiple files. Now that I have seen the solution to the problem I recall having unhidden this PERSONAL workbook that gets created, just cannot recall as to why I would have done it.

Answer 6

Unhiding and re-hiding the personal.xlsb would get rid of the window for one session for me, but it wouldn't go away for good. So I added a marco that would automatically run every time I opened Excel to re-hide personal.xlsb. Here is the code:

Private Sub Auto_Open()

   Windows("PERSONAL.XLSB").Visible = True
   Windows("PERSONAL.XLSB").Visible = False

End Sub

If you add this to a module in Personal.xlsb it will run any time Excel is opened and will remove the second window.

Answer 7

In my case I simply couldn't delete macros workbook as it was full of macros. What helped me was to make personal.xlsb file visible, modify it slightly (I changed the columns width), re-save it and hide again. And voila - the additional blank window doesn't appear anymore! It looks MS has made some changes into xlsb file format and the file needs updating.