Posts

Showing posts from September, 2014

Fix Excel Error - The file you are trying to open is in different format than specified by the file extension

Image
I got below error message when I tried to open my Excel file:

“The file you are trying to open is in different format than specified by the file extension. Verify that the file is not corrupt and is from a trusted source before opening the file. Do you want to open the file now?”


I clicked on the ‘Yes’ button to open my file.



But MS Excel did not open my file. There is a blank workbook. I was shocked because we were updating this workbook since last three years. 


This is how I repair it:

Open & Repair: I tried this method by following below steps:
Office Button->Open->Select your file->Click arrow next to open button->Open & Repair

When I tried above steps, got another pop-up message
“Excel can perform checks while opening the workbook and attempt to repair any corruption it detects, or extract just the data (formulas and values) from the workbook.
•    Click Repair if you want to recover as much as of your work as possible.
•    Click Extract Data if Excel was previ…