Clarity: When Exporting to Excel a portlet we receive a warning that the fileformat differs from the format that the file name extension specifies

Document ID : KB000049787
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When we Export to Excel any portlet we receive a warning that the file format differs from the format that the file name extension specifies.

The file you are trying to open, <name.ext>, 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?

Note: The name placeholder is the file name and the ext placeholder is the file name extension of the file that you open in Excel 2007.

Figure 1

Solution:

IMPORTANT: This article contains information about modifying the registry.
Before you modify the registry, make sure to create back up of the registry and ensure that you understand how to restore the registry if a problem may occur.
For more information about how to back up, restore, and edit the registry, please review the relevant Microsoft Knowledge Base articles on support.microsoft.com.

This is a known Microsoft issue as discussed in Article ID: 948615 (http://support.microsoft.com/kb/948615) and also in the following Microsoft Blog site (http://blogs.msdn.com/b/vsofficedeveloper/archive/2008/03/11/excel-2007-extension-warning.aspx).

Cause:
The warning message is a user-notification function that was added to Excel 2007. The warning message can help prevent unexpected problems that might occur because of possible incompatibility between the actual content of the file and the file name extension.

Solution:
Advise your users that because this is coming from your Clarity instance, then it is a trusted source of the file and to click Yes to the warning message.

Keywords: CLARITYKB, popup, e2e.