Asked By
erwinlogs
0 points
N/A
Posted on - 08/04/2011
Hi guys, I have an issue here regarding my XLS file.
I downloaded from the internet a data sheet that I needed most.
When I opened it with Microsoft Excel it cannot be opened instead it displayed an error message.
Microsoft Excel
The File you are trying to open, UNCFORMS%200N%20MAND.xls’. Is in a different format then specified by the file extension Verify that the file is not corrupted and is form a trusted source before opening the file. Do you want to open the file now?
Yes No Help
I pasted above the error message for your reference of my problem.
When I analyzed the error above, it seems that the file is corrupted, that is why I decided to download again another copy of the file.
But when I opened it, same problem occurred.
Please help me look for some solution to my problem.
Hoping to hear from you soon.
Thanks.
Answered By
Orabel
240 points
N/A
#98330
Verify that the file is not corrupted
Erwin,
You may try the following method to resolve the issue:
-
Click Start, and open the Run Command window.
-
Type “regedit” (without quotes) in the window and press ENTER.
-
Locate and then click the following registry key depending on the version of Outlook that you are using:
Outlook 2002: HKEY_CURRENT_USERSoftwareMicrosoftOffice10.0ExcelSecurity
Outlook 2003: HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0ExcelSecurity
Outlook 2007: HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0ExcelSecurity
4. Right click in the right window and choose New -> DWORD
5. In the Name field, type “ExtensionHardening“ (without the quotes)
6. Verify that the data has the value “0″
7. Exit the editor and check whether the issue is resolved.
For more info: When you open a file in Excel 2007, you receive a warning that the file format differs from the format that the file name extension specifies
It is always advisable to back up the registry while modifying the registry.
Please visit the following web link for more information: How to back up and restore the registry in Windows XP
Cheers.
Orabel
Verify that the file is not corrupted
This is actually not an error in Microsoft Excel or in the Excel file that you downloaded. The message only informs you that the file you downloaded was created and saved using a different format and its current extension name doesn’t match it.
It is possible that the Excel file was created under Microsoft Excel 2007 and was saved under the .xlsx format but later was renamed to .Xls.
You can verify if the file is really corrupt by actually opening the file. In the dialog box that you see, you should select Yes to open the file. But before opening the file, be sure that you have an antivirus running to protect your system from any harmful macros that the file might contain.
But if the file turns out to be corrupted, try repairing it using Microsoft Excel also.
When opening the file, select Open and Repair instead of the usual Open.
Then just follow the on-screen instructions afterwards.