IBM Support

MSG_Ribbon seen with the IBM Planning Analytics tab after upgrading to Planning Analytics for Excel (PAFE) version 68

Troubleshooting


Problem

MSG_RIB_DESIGNMODE_OFF and MSG_RIB-FORMULA_WB_MODE seen in the IBM Planning Analytics ribbon after upgrading to PAfE 68. It should display as "Design Mode" and "Writeback Mode".

Symptom

image 11733

Cause

Unrecognizable content detected in the "Language Resources" folder located within the Office Connection. 

Environment

Planning Analytics for Excel version 68

Resolving The Problem

With Excel completely closed, Navigate to the Office Connection folder located at:
C:\Users\User you are logged in as\AppData\Local\Cognos\Office Connection
Once there, Delete the LanguageResources folder. 
Launch Excel again and click the IBM Planning Analytics ribbon. You will notice the correct values displayed now. 
It will also create a new LanguageResources folder that will re-initialize the Strings. 
Note: IBM has accepted this as a defect in Planning Analytics for Excel version 68 and is working towards a fix which will be released in one of the coming releases.

Document Location

Worldwide

[{"Type":"MASTER","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":"a8m0z000000GoRcAAK","label":"1 - Migrated Categories-\u003EBA - Planning Analytics Cloud-\u003ETroubleshooting-\u003EPlanning Analytics For Excel"}],"ARM Case Number":"TS007200637","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
19 November 2021

UID

ibm16500929