posted by Oracle yesterday, Sep-06-2016

Information Regarding NEW Smart View Installs: New Installs Displays Certificate Message: “Warning: The digital signature on the application add-in is invalid and cannot be trusted. Application add-in is disabled.The following new My Oracle Support Knowledge Article is available:

Doc ID 2174747.1

per the document:

Applies to:

  • Hyperion Essbase – Version 11.1.2.4.000 and later
  • Hyperion Planning – Version 11.1.2.4.000 and later
  • Hyperion Financial Management – Version 11.1.2.4.000 and later
  • Generic Windows
  • This issue applies to all versions of Smart View

Symptoms

After installing Smart View and opening Excel, a Microsoft Office Security Options window opens with:

“Warning: The digital signature on the application add-in is invalid and cannot be trusted. Application add-in is disabled.”

This affects all new installations of Smart View. Existing installations are not impacted.

Changes

New installation of Smart View.

Cause

The certificate for the “Digital Signature” for the HsTbar.xla has expired. This is used for Spreading and VBA’s.

Solution

To workaround the certificate warning:

  1. Install Smart View (“Run as Administrator”). Do not launch Excel prior to performing the next step. 
  2. Rename the HsTBar.xla file to HsTBar.xla_badcert.  This file is located in the \SmartView\bin folder. 
  3. Launch Smart View.