Mac – How to stop Excel from opening a second blank window when opening a file from Explorer

macrosmicrosoft excelmicrosoft-excel-2013

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:

How can I stop this second window appearing?

Best Answer

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.

Related Question