Fix Excel .XLSX Files That Will Not Open by Restoring File Associations
Question details
The user needs to restore the application association used to open .xlsx Excel workbooks.
- Product
- Microsoft Excel and .xlsx files
- Device & OS
- Windows and macOS
- Scenario
- An .xlsx file stored locally or in cloud storage prompts the user to select an app instead of opening in Excel.
- Observed behavior
- The operating system does not automatically open the .xlsx file with Microsoft Excel.
Confirm the file name ends in .xlsx and that the workbook is fully downloaded from iCloud, OneDrive, or another cloud service. Keep one local .xlsx file available for testing the association.
Restore the .XLSX association with Excel on Windows
Use this solution when Windows asks you to choose an app or opens .xlsx files with the wrong program.
Changing the default app for the .xlsx extension tells Windows to launch Excel whenever you open an Excel workbook. The cloud storage location does not determine the associated application.
In File Explorer, right-click an .xlsx file and select Open with > Choose another app. Select Microsoft Excel, enable Always use this app to open .xlsx files, and click OK.
Open Windows Settings, select Apps > Default apps, search for .xlsx or choose defaults by file type, then select Microsoft Excel for the .xlsx extension.
If the file is in iCloud or OneDrive, wait for synchronization to finish, download the file to the computer, and double-click it again.
In Excel, go to File > Options > Advanced > General and clear Ignore other applications that use Dynamic Data Exchange (DDE), then restart Excel and test the file.
Set Excel as the default .XLSX app on Mac
Use this method when Finder does not open .xlsx files in Excel or repeatedly asks you to select an application.
Open the workbook with WPS Office
Use this option when you need a compatible spreadsheet editor immediately or Excel is not installed.
Open and manage .XLSX workbooks with WPS Office
WPS Office can open .xlsx files directly in WPS Spreadsheets and can be selected as the default application when Excel is unavailable or its file association is broken. Its familiar interface helps you continue editing without changing the workbook format.
- 1. Install WPS Office: Download and install WPS Office, then launch it from the desktop or Start menu.
- 2. Open WPS Spreadsheets: From the WPS Office home screen, select Spreadsheets and choose Open to browse for the workbook.
- 3. Select the .XLSX file: Choose the downloaded .xlsx file and open it in WPS Spreadsheets.
- 4. Set WPS as the default app: If you want future .xlsx files to open in WPS, right-click one in File Explorer, choose Open with > Choose another app, select WPS Office, and enable Always use this app.
Frequently Asked Questions
Why does Windows ask me to choose an app for an .xlsx file?
The .xlsx file association is missing, damaged, or assigned to an unavailable application. Right-click the file, select Open with > Choose another app, choose Microsoft Excel or WPS Office, and enable Always use this app.
How do I make Excel the default program for .xlsx files in Windows?
Open Settings > Apps > Default apps, choose defaults by file type, find the .xlsx extension, and select Microsoft Excel as its default application.
How can I change the .xlsx default app on a Mac?
In Finder, right-click an .xlsx file and select Get Info. Choose Microsoft Excel in Open with, click Change All, and confirm the change.
Can iCloud or OneDrive prevent an Excel file from opening?
Cloud storage usually does not control the file association, but an incomplete download can prevent opening. Wait for synchronization to finish or download the workbook locally, then try again.
What should I check if Excel is associated with .xlsx files but the file still will not open?
In Excel, open File > Options > Advanced > General and clear Ignore other applications that use Dynamic Data Exchange (DDE). Restart Excel, update Office, and repair the installation if the problem continues.
