text: Because your closing the whole Excel. \n\nWhen you open a file. And you have excel loaded with an existing workbook it just creates another workbook on top of the one you are working on.  \n\nBy clicking on the X button on the very upper right hand corner it closes everything. There should be another X button but somewhat  below your toolbars to close individual workbooks