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

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

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.