If Excel prompts you to save the save the file, click "Save" to continue. The "Select Files to Merge into Current Workbook" dialog window opens and displays a list of your Excel files.