Troubleshooting
Problem
Users may experience IBM Planning Analytics for Microsoft Excel returning #VALUE errors when evaluating DBRW formulas. This may be due to conflicting 'Lotus compatibility Settings' in Microsoft Excel.
Symptom
Evaluating DBRW formulas returns #VALUE errors.
Cause
Conflicting 'Lotus compatibility Settings' in Microsoft Excel.
Resolving The Problem
In Microsoft Excel, navigate to File > Options > Advanced > Lotus compatibility Settings for: > Uncheck 'Transition formula evaluation' and 'Transition formula entry'.
[{"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Planning Analytics v2.0 for Microsoft Excel","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg22003425