xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." It usually indicates the file is not compatible with the Excel version of the file that has come corrupt or damaged.

Then, why can't I open .xlsx files in Excel?

Method 1.

But Excel since 2007 saves files in the XLSX format. A mismatch between file extension and Excel version may cause the error “Excel cannot open the file because the file format or file extension is not valid”. Open Excel and, on the taskbar, select File. Then select Options -> Export -> Change File Type.

One may also ask, how do I open an unsupported Excel file? While there are file converters out there, the most common way to get an unsupported file format into Excel is:

  1. Open the unsupported data file with the software used to create it.
  2. Use the Save As or Export functions to save the file in either Comma-Separated Values (CSV) or XLS(If Supported) file format.

Considering this, how do I open XLSX files in Excel?

How to open an XLSX file

  1. Step 1: Double click on the XLSX file. To open XLSX files in Excel, simply double click on the file.
  2. Step 2: Drag and drop the XLSX file onto an Excel window to open it.
  3. Step 3: “Open with” – open the XLSX file in Excel using the right-click menu.

How do I open a XLSX file in Excel 2016?

You can go to File>Account>Product Information to check it. For example: 1708(8431.2031) Your Windows version. For example, version 1703.

Newly-installed Excel 2016 won't open . xlsx files

  1. Opening the Excel file.
  2. Excel opens, but not the file.
  3. I try opening the same file from within Excel.
  4. And it opens.

Related Question Answers

Which app is needed to open XLSX files?

A file with the . xlsx file extension is a Microsoft Excel Open XML Spreadsheet (XLSX) file created by Microsoft Excel. You can also open this format in other spreadsheet apps, such as Apple Numbers, Google Docs, and OpenOffice.

How do I convert XLSX to Excel 2007?

How to convert a XLSX to a XLS file?
  1. Choose the XLSX file that you want to convert.
  2. Select XLS as the the format you want to convert your XLSX file to.
  3. Click "Convert" to convert your XLSX file.

How do I convert XLSX to XLS 2016?

xls format in Excel.

To get started, kindly perform the following steps:

  1. Open File Explorer.
  2. Go to the View Tab.
  3. Tick File name extensions under Show/Hide.
  4. Go to the folder where you Excel file is stored.
  5. Right-click on the Excel File.
  6. Select Rename.
  7. Rename ". XLSX" to ". XLS".
  8. Click Enter once done.

How do I recover an XLSX file?

Method 1. Restore Deleted Excel from Recycle Bin
  1. Open Recycle Bin and find deleted . xlsx or . xls files inside it.
  2. Right-click on lost XLSX/XLS files and select "Restore". Then the deleted . xlsx or . xls file will be restored to the original location on your PC.

How do I remove Xlsx from Excel?

If you know the password that protect worksheet and workbook, remove read only in excel file would be so easy.
  1. Open your excel file in MS Excel and you can view all worksheet and its content.
  2. Click Unprotect Sheet under Review > Changes group, and enter password to unprotect sheet one by one.

Which version of Excel is XLSX?

Microsoft Excel

Which is better XLS or XLSX?

XLS files are larger than XLSX files. XLS is a proprietary binary format, whereas XLSX is based on Microsoft Office Open XML format. In the files that require the use of complex formulas with big sets of data, XLS works faster than XLSX. XLSX can hold data in large quantities, but XLS can store fewer data.

How do I open XLSX files without Excel?

How To Open Excel File Without Excel?
  1. Using Chrome Browser's Free Extension. You can open XLS/XLSX file easily in your Chrome browser just by using a free extension.
  2. Excel Viewer.
  3. Apache OpenOffice.
  4. Microsoft Office Compatibility Pack.
  5. XLS Viewer 2.30.
  6. Google Docs.
  7. Zoho Sheets.
  8. WPS Office.

What is difference between XLS and XLSX?

XLSX is the latest version of Microsoft Excel while XLS is the oldest version. XLS was developed based on the version of Excel prior to 2007 whereas XLSX was developed based on the version of Excel 2007 and onward. XLSX is an open XML format while XLS is a binary format.

How do I convert XLS to XLSX?

How to convert XLS to XLSX online for free
  1. First, save the XLS to PDF.
  2. Download the first file, and then click 'PDF to Excel' on the footer.
  3. Drag the downloaded file into the second, darker green toolbox.
  4. It will now convert to XLSX. Download this file.

How does an Excel file get corrupted?

Excel files can get corrupted if they were not saved properly, this could be because you did not shut down the program properly or if it shut down abruptly because of a power failure, hardware failure, or because of a virus or malware attack.

Can I open an Excel 2007 file with Excel 2016?

xlsm) file format is supported by Excel 2016. Kindly refer to the below mention article on the file format supported by Excel 2016 for more information. I suggest you to try repairing the workbook and then open to check if it work as expected.

Can XLSX files contain virus?

A . xlsx file may briefly contain a macro virus while that file is open in Excel. However, saved copies of that file are rendered “safe” because all VBA code (including the macro virus) will be removed automatically as part of the “save” operation.