Question & Answer
Question
Normally data updated cell toggle the font color to blue. However, my worksheet stay in black.
How can I revert to toggle the color?
Cause
Customer changed format in Planning Analytics for Microsoft Excel .
Answer
In default, Planning Analytics for Microsoft Excel use "Use Server Formats". This behavior caused by user changed format option to "Use Excel Formats".
If you want to change the font color to blue when data change, you need to use "Use Server Formats".
Related Information
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"Planning Analytics for Microsoft Excel","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
30 September 2018
UID
ibm10733549