text: two excel file open one time but one close and secount auto closed why?........?   because your closing the whole excel.   when 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.    by 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