One day our Cognos users began experiencing slow performance of Cognos Analysis for Excel (Cognos CAFE).
We use
TM1 10.2.2 FP7 (TM1 Build Number: 10.2.20700.43)
CAFE 10.2.2 FP7
MS Office 2013
I tried different ways to increase performance due to IBM recommendations but there was no effect. https://www.ibm.com/support/knowledgece ... s_cor.html
Files in Office Connection directory (C:\Users\Username\AppData\Local\Cognos\Office Connection) are the same for both versions of Excel.
I have no idea why this is happening except the theory that users became facing slow CAFE performance after Excel updates.
For example in Excel version 2013 (15.0.4569.1504) MSO (15.0.4569.1506) CAFE works well & quickly
In Excel Version 2013 (15.0.5093.1000) MSO (15.0.5101.1000) it works very very slowly.
We cannot rollback excel updates because all microsoft products must be up-to-date in our company.
If anyone has any ideas how to fix slow performance I will appreciate it very much