IBM Support

Perspectives - labels missing on TM1 icons in Excel



Launching of Perspectives shows the TM1 icons in the Excel ribbon, but the labels for them are missing.


User may also see the warning that the digital signature has expired on the Enable Macros window and/or the Please insert a Smart Card message.


Windows 7 and Excel 2010

Resolving The Problem

Solution is to trust the tm1p.xla location (the TM1 x86 bin folder) in Excel. To do that in MS Excel 2010 go to File > Options > Trust Center > Trust Center Settings > Trusted Locations and add new location

It may also be necessary to disable the Developer tab by going to Customize the Ribbon (right-click on ribbon) and unchecking the Developer option.

For Excel 2007:
Click the Microsoft Office ButtonButton image, and then click Excel Options.

Click Popular, and then de-select the Show Developer tab in the Ribbon check box.

Note: If the TM1 ribbon is set to auto=load when launching Excel, setting it not to do that may also be a contributory factor in this issue. Logically, it should be possible to utilize the Developer tab when launching Excel without TM1. Then when TM1 is needed, simply launch TM1 directly from the tm1p.xla file or from Start > All Programs > IBM Cognos TM1.

The majority of users will not be developing and will not need the Developer option in Excel anyway.

IBM is, so far, unable to reproduce this issue in-house, so we have been unable to log a defect.

In some cases the above may not resolve the issue. If that doesn't resolve it, make sure that if 32bit Excel is being used that 32bit Perspectives (tm1p.xla) is also being used. Likewise, if 64 bit Excel is being used, be sure to use the 64bit Perspectives. See technote link below.

Related Information

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Perspectives","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.0;10.1.1;10.2;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018