Tell me the best way to stop excel from opening blank windows?

When i open an excel file in the windows explorer i always get a second excel window Annoyingly, when i close it, it doesn't close, but the other window does!

This seems to be a common problem

• 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

What should i do to stop the second window from showing up?

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.