Exporting to Excel does not work

Problem:

Exporting to Excel does not work. The error can manifest itself in various ways. For example, nothing may happen when the corresponding functions are executed or an error message may be displayed stating that the file cannot be found. Such problems can occur both with functions in the product and in project-specific implementations.

Cause:

The cause is a changed behavior in Microsoft Excel regarding sensitivity labels and a deficit in the Interop.Excel Library, which is used in our functions for creating Excel files. As a result, the file is not created when the Excel document is called up for saving. Depending on the implementation, an error message stating that the file cannot be found is then displayed when the Excel file is subsequently called up for display or nothing happens.

Prerequisites for this behavior are:

• Use of a current Excel version
• Use of the sensitivity labels
• Mandatory specification of a sensitivity label by the own organization
• No specification of a standard sensitivity label

Solution:

Due to the deficit in the Interop.Excel library, the problem cannot be solved within our application. The only workaround is currently the specification of a standard sensitivity label