Question posted by linomileto on May 5th, 2015

Excel Cannot Open 'file.xlsx'

Excel cannot open file 'file.xlsx' because file format or extension is not validEvery now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

Current Answers

Answer #1: Posted by bungabin on May 6th, 2015 11:57 AM
This answer was accepted by the poster of the original question.
bungabin

Member since:
May 6th, 2015

Points: 1,120
1,120
points
I came across this issue today. An update to the Office Compatibility Pack that was still on a computer caused the default PROGRAM for .docx and .xlsx files to be the Microsoft Open XML Converter program and make the "Default Programs" in Control Panel think that Excel and Word were actually the Microsoft Open XML Converter scholarship essay writing assistance program as well.

UNINSTALLING the Office Compatibility Pack in Programs and Features and then a simple reboot fixed the issue.

Also:

1: Try to repair it manually when MS Excel does not automatically STARTS File recovery mode.

Click the Microsoft Office Button, and then click OPEN.

Now select the corrupted workbook that you want to open.

Click the arrow NEXT to the Open button, and then click Open and Repair.

Choose either Repair (to recover as much of the FILE data) or Extract data (to extract values and formula when repair process is not successful).

2: Open with Open Office: Try to open your Excel file in Open Office. It is an open-source Office suite that is able to open & SAVE Microsoft Excel files.

3: Save in HTML Format: Open your Excel file and save it in HTML format. By saving the workbook in HTML format, you may be able to filter out the corrupted elements.

4: Save in SYLK Format: Open your Excel file and save it in SYLK format. By saving the workbook in SYLK format, you may be able to filter out the corrupted elements.

5: Try 3rd party software like Excel Repair Toolbox

link: https://www.repairtoolbox.com/excelrepair.html

Answer #2: Posted by hzplj9 on May 5th, 2015 11:49 AM
hzplj9

Member since:
June 25th, 2012

Points: 4,875,670
100
points
You'll need to update your Excel. This link will explain.

http://file.org/extension/xlsx

Answer #3: Posted by TechSupport101 on May 5th, 2015 12:02 PM
TechSupport101

Member since:
May 24th, 2013

Points: 12,171,285
100
points
Visit the official Microsoft support page for assistance with the issue.

Similar Questions

Microsoft Powerpoint 2010 Opening Pptx Files As A Picture Icon
I've got a user on a Windows 7 (x86) laptop with Microsoft Office 2010 installed, alongside Microsof...
(Posted by Stevenson66 8 years ago)
Powerpoint Files Not Opening
The company I work for has developed it's own on-line training modules using powerpoint and then con...
(Posted by berndtbecke 8 years ago)
How To Open A Bak File In Corel Draw 5?
I have been having some troubles with my Corel Draw lately. First off, I no longer have the software...
(Posted by GunterKruse 8 years ago)
When I Open Onenote, All The Files Are Outdated Notes
Hi guys, need your help here... My Windows 7 Asus crashed yesterday and I and i had to reinstall Win...
(Posted by girossapoh 8 years ago)
Why Cant Microsoft Open Files
keeps saying click 2 open configeration error
(Posted by berylnewland 10 years ago)
Ask a New Question
Use the box below to post a new question about Microsoft.
Points & Prizes
  • You can earn points for nearly everything you do on HelpOwl.com
  • You can trade in those points for gift cards at leading retailers such as Amazon.com and Walmart
  • It's that simple!
See How it Works
Create a Free Account

Microsoft Manuals

Find free Microsoft manuals and user guides available at ManualOwl.com. Try out our unique manual viewer allowing you to interact with manuals from directly within your browser!

Microsoft Reviews

View thousands of Microsoft user reviews and customer ratings available at ReviewOwl.com.

Contact Information

Complete Microsoft customer service contact information including steps to reach representatives, hours of operation, customer support links and more from ContactHelp.com.

Scoreboard Ratings

See detailed Microsoft customer service rankings, employee comments and much more from our sister site.