IBM Support

Controller Excel Report Performance Tips

Troubleshooting


Problem

Customer is experiencing slow Excel-based report performance. Is there a way to speed up how long it takes to refresh spreadsheet reports with Controller?

Symptom

Slow report performance when using Excel-based reports.

  • Typically these are Controller Excel link reports, which use fGetVal formulae, and are triggered/run via F9.

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"Edition Independent","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","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.

Historical Number

1037260

Document Information

Modified date:
08 May 2025

UID

swg21347497