Format and file extension specified format is not consistent

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

With the C# derived excel, open is always a hint:

The file you are trying to open “ test.xls” format with the file extension specified format is not consistent. Open the file first verify that the file is not damaged and is from a trusted source. Whether to immediately open the file?

Click Yes, can open, but there is always this hint, feel very uncomfortable.

To provide a solution, have been tested, effective:

 1,Close all office applications, and then open the registry, enter regedit in the operation, you can use shortcut keys to open running win+R window.

2,Find the following position: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security

Point [Edit] [new] on the menu, click DWORD, and then enter the ExtensionHardening, finally enter ENTER.

3,Right click ExtensionHardening, click Modify, and then enter the value 0. Click on the menu in the exit.


Then open the excel file, found that prompt disappeared.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Miya at November 14, 2013 - 3:13 AM