IBM Support

Planning Analytics for Excel (PAfE) shows #NAME on refresh - check that the add-in is enabled

Troubleshooting


Problem

The data content and cell values in PAfE show #NAME on refresh.

Cause

The IBM Cognos Office Reporting TM1 add-in gets disabled while one is still logged in to a TM1 instance.

Environment

Microsoft Excel on Windows. Note, only Windows OS is supported.

Diagnosing The Problem

Check whether you have a software distribution package that installs PAfE but is not set to enable it by default.

Resolving The Problem

To enable the add-in:
  1. In Excel, go to File and click Options.
  2. Click Add-ins.
  3. Scroll down to Manage and click Go... .
  4. In the list of available add-ins, IBM Cognos Office Reporting TM1 must be selected.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m50000000KzJ4AAK","label":"Planning Analytics for Microsoft Excel"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Type":"MASTER"}]

Document Information

Modified date:
20 September 2021

UID

ibm10961514