Monday 25 September 2017

Is there any way to suppress the Excel 2007 warning "in a different format than specified by the file extension"?


We have an application that exports data using the older Office XP/2003 XML Spreadsheet format. These files are saved with a .xls extension so that they can be launched directly, without having to know the installation of Excel.


This has worked extremely well for us up until now. However, we have just recently upgraded to Office 2007, and when we launch these .xls files directly, Excel 2007 shows a warning message:



The file you are trying to open, 'file.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. Do you want to open the file now?



I have already tried adding the location of the file to the "Trusted Locations" in Excel, but the warning message still comes.


Is there any way to suppress this message?



Answer



1) Exit Excel 2007.
2) Start Registry Editor.
3) Locate and then click the following registry subkey:



HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security



4) On the Edit menu, point to New, and then click DWORD Value.
5) Type ExtensionHardening, and then press ENTER.
6) Right-click ExtensionHardening, and then click Modify.
7) In the Value data box, type 0, and then click OK.


The following list contains the value data settings that are appropriate for the ExtensionHardening setting:



0: Do not check the file name extension and the file type, and bypass the function of the warning message.
1: Check the file name extension and the file type. If they do not match, display the warning message.
2: Check the file name extension and the file type. If they do not match, do not open the file.



Note: The default value data is 1. When the value data is set to 1, the behavior becomes the same as when no registry value is set. When the value data is set to 0, the file name extension and the file content are not checked in all situations. It is not recommended bypassing this function.


8) On the File menu, click Exit to exit Registry Editor.


No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...