IBM Support

Setting Excel to manual calculation as default.

Question & Answer


Question

Microsoft Excel is set to automatic calculation mode by default. Changing this to manual only lasts for the current session, therefore the next time Excel is launched, the calculation mode is again automatic. Is there a way to set TM1 Perpsectives to always use Excel in manual calculation mode?

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"TM1 Perspectives","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5.2;10.1.0;10.1.1;10.2;10.2.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
Cognos TM1

Software version:
9.5.2, 10.1.0, 10.1.1, 10.2, 10.2.2

Operating system(s):
Windows

Document number:
480223

Modified date:
09 May 2025

UID

swg21613452

Manage My Notification Subscriptions