We are about to update from TM1 9.1.2 to 9.5.2.
While testing our own xls-reports (with macros, Excel 2003) we see unusual screen flickering while macro execution.
Everytime
Code: Select all
Application.Run("TM1RECALC1")
Since we have elaborate macros with a couple of TM1RECALCs in a row. Our TM1 users don't tolerate the flickering while macro execution. After revising the code by adding
Code: Select all
Application.Screenupdating = False
Is there a way to undo / deactivate the command "Application.ScreenUpdating = True" in the tm1p.xla (Version 9.5.2, 32-bit)?
This command must have been added after TM1 9.1.2. In this version there is no flickering. To prevent excel from screen updating it used to be sufficient to set "Application.Screenupdating" at the beginning and at the end of a Sub.
Using
Code: Select all
Application.Visible = False / True
I found PM33830 during a web search and informed our TM1 consultants to contact the IBM support regarding this open support case. A VBA or Excel workaround would also be appreciated.
Business impact
Without removing "Application.Screenupdating = True" in tm1p.xla or an adequate workaround, we must postpone the TM1 9.5.2 update.
Thank you for any hint.