If needed, open the file in Excel, save it as the correct format, and close it to apply changes. Why is my XLSX file not opening in Excel? If your XLSX file isn’t opening in Excel, you might not ...

Before merging, ensure you have all the Excel files open. Only when they are open can the Excel merge function choose a destination. You can also move sheets from multiple files into a new Excel file.