Verify that the file is not corrupted

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Orabel
Best Answer
Best Answer
Answered By 240 points N/A #98330

Verify that the file is not corrupted

qa-featured

Erwin,

You may try the following method to resolve the issue:

  1. Click Start, and open the Run Command window.
  2. Type “regedit” (without quotes) in the window and press ENTER.
  3. 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

Answered By 590495 points N/A #98331

Verify that the file is not corrupted

qa-featured

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.

Related Questions