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:

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)

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
IBM Cognos Controller

Software version:
10.1, 10.1.1

Operating system(s):
Windows

Document number:
476465

Modified date:
08 May 2025

UID

swg21596432

IBM Support

Tips