How can I stop Excel from opening a second blank window when opening a file from Explorer?
Solution 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.
Solution 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.
Solution 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.
Solution 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
Solution 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.
Related videos on Youtube
Deanna
Updated on September 18, 2022Comments
-
Deanna over 1 year
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?
-
Standin.Wolf over 6 yearstechwalla.com/articles/… This link helped me out
-
Alaa M. about 6 yearsFile > Options > Add-Ins > [on the bottom] Manage: COM Add-ins > Go > disable MySQL For Excel
-
SIM about 5 yearsCheck out the most voted answer provided by
Girish M
in the linked post.
-
Deanna almost 9 yearsLooks likely, I'll text this later.
-
CBHacking over 8 yearsCan you tell us what the removed file was? Also, did the add-in show up in the "Manage Add-ins" view of the Settings screen (within Excel), and if so, does it still show up or did you end up removing it?
-
Adam Nofsinger over 8 yearsI had to get rid of my old PERSONAL.XLSB and then copy and paste the macro content into a new one, created by Office 2016.
-
tbone over 7 years"switch to the Personal.xlsb file" - how???
-
Cold_Class over 6 yearsfinally a location that actually existed on my computer! :D Except my file's name was not "PERSONAL" and I didn't knowingly create any Macros - I just deleted all the files in there and everything worked again.
-
Amit Naidu about 6 yearsI am seeing a similar scenario in Excel 2013 office15 where the HP ALM related
TDExcelAddin.xla
has been conflicting with personal.xlsb for some users, causing these ghost windows. It is not clear why. Disabling either of these two fixes it. -
Amit Naidu about 6 yearstbone: you can go to the View tab, click Unhide, and select personal.xlsb in the popup dialog.
-
omatai over 5 yearsFixed it for me... as well as fixing an issue with always prompting to save unchanged worksheets. I also had MySQL for Excel, and a couple of add-ins related to Visual Studio.
-
MikeB over 5 yearsThe "MySQL for Excel" add-in was specifically causing the extra sheet on my machine. Thanks for the tip!
-
David A. Gray over 5 yearsJudging from my own experience and those already noted, I suspect that the guilty party is MySQL for Excel, since it appears twice in the answer and comments, and is also in my own list. The other two COM add-ins in my list were Team Foundation for Excel and Visual Studio Tools for Office Design-Time Adaptor for Excel, neither of which I have ever used. Since bothwere instqalled last year, I suspect that neither was involved.
-
user9623 over 5 yearswhats the connection between opening two excel windows and MySql?
-
SimonC about 5 yearsRemoving this file also resolved the issue for me. Will keep an eye on the folder for a while and make sure it doesn't happen again
-
xinthose about 5 yearsI started noticing this issue after connecting to a MySQL database using the Add-in. The issue stopped after I disabled it.
-
jirimertin about 5 years@ThomasGassman, code formatting shouldn't be used for things that aren't actually code.
-
Veloz almost 5 yearsMySQL Add-in was the culprit for me as well.
-
Bort about 3 yearsI have no PERSONAL.xlsb in any folder. Removing file C:\Users\xxx\AppData\Roaming\Microsoft\Excel\Excel15.xlb fixed the problem.