IBM Support

Errors in Excel link (e.g. Data Entry) due to File Block settings (Trust Center) in Excel 2010

Troubleshooting


Problem

User clicks "Company - Data Entry - Reported Values". User chooses parameters, and then clicks "Open" (to open the data entry form). User receives an error.

Symptom

Microsoft Excel

You are attempting to open a file type (Excel 95-97 Workbooks and Templates) that has been blocked by your File Block settings in the Trust Center.

This error occurs when you open a Microsoft Office file type blocked by File Block settings in the Trust Center. To enable this file type, do the following:

  • Click the File tab.
  • Under Help, click Options.
  • Click Trust Center, and then click Trust Center Settings.
  • In the Trust Center, click File Block Settings.

To save documents with this file type, disable the registry policy setting. For more information, see Microsoft Knowledge Base article 922850.

    German:
    Sie versuchen, einen Dateityp zu (Excel 95-97-Arbeitsmappen und –Vorlagen) öffnen, der durch Ihre Zugriffsschutzeinstellungen im Sicherheitscenter gesperrt wird.
    (...)


If the user clicks OK then a second error appears:

Standard Error
Source: ControllerForms12
Description: OpenWorkbook
You are attempting to open a file type that is blocked by your File Block settings in the Trust Center.
at Cognos.Controller.ControllerForms12.clsDataEntry.ActivateDataEntryForm()
at Cognos.Controller.ControllerForms12.clsDataEntry.OpenSelectedForm(UserParameters& UserSelection)

Cause

Both of the following are true:

  • The form has been created inside an older version of Excel
  • The Excel File Block setting "Excel 95-97 Workbooks and Templates" has been enabled/ticked:


This disallows older Excel file types to be opened/saved.

Environment

Client device has Excel 2010 installed.

Resolving The Problem

Fix:

Update the forms' file type by running a process layout

  • In other words, run a 'process layouts' on all forms. This will save the forms in the latest (Excel) file format.

Workaround:

Allow to open Excel 95-97 Workbooks and Templates in Excel 2010 Trust Center's File Block settings

Steps:

1. Launch Excel

2. Click "File - Options"




3. Click "Trust Center - Trust Center Settings...":


4. Untick the option "Excel 95-97 Workbooks and Templates":

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21596432

Page Feedback