Enable the add-in required to work with TM1 worksheet functions

To work with worksheet functions in IBM® Planning Analytics for Microsoft Excel, the TM1® add-in must be enabled. The add-in is enabled by default when you install IBM Planning Analytics for Microsoft Excel. If the add-in is disabled, however, you can enable it.

The IBM Cognos® Office Reporting TM1 add-in is installed in [installation_location]\IBM for Microsoft Office. The file name is CognosOfficeTM1.xll.

For information about enabling add-ins, see the Microsoft Excel Help.