Solved

Error opening file: "The file format differs from the format that the file name extension specifies" in Excel

Posted on 2014-07-20
3
1,393 Views
Last Modified: 2014-07-24
Hello guys,

Can you please solve this problem for me..i have attached an excel sheet too..
''Error when opening an Excel file: "The file you are trying to open, '.xls.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file..."

Please help
Thanks
0
Comment
Question by:techlabtest
3 Comments
 
LVL 8

Expert Comment

by:itjockey
ID: 40208287
No attachment..!!!
0
 

Author Comment

by:techlabtest
ID: 40208360
Check please...

Thanks
Daily-Sales-01.07.14.xls
0
 
LVL 20

Accepted Solution

by:
n2fc earned 500 total points
ID: 40208418
Message couldn't be clearer...

The file, although it has an "xls" extension is truly NOT an Excel file...

The message tells you to verify the source from whence it came, as it is either corrupt, damaged, or infected!

Perhaps someone created the file with another program and just renamed it...
Perhaps another program is defective and generated that file badly...

In any case, Excel can't process it!
0

Featured Post

Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
macro for each dropdown 15 44
Changing Print Orientation in Outlook 5 21
Excel case statements 3 24
Office 365 Excel Connect to a SQL database 2 7
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now