Search found 5 matches

by Ben Stremme
Wed May 23, 2012 9:01 am
Forum: Bugs
Topic: TM1RECALC bug in an event
Replies: 10
Views: 16045

Re: TM1RECALC bug in an event

IBM recently solved this bug. It is part of the hotfix "IBM TM1 9.5.2 FP2 HF2"
PM56397 - TM1 Perspectives Office 2010 – Using TM1 Recalc1 causes Excel Crash.
Now TM1RECALC/TM1RECALC1 in a Worksheet_Change Sub should work again.
by Ben Stremme
Tue Jan 10, 2012 3:37 pm
Forum: Bugs
Topic: TM1RECALC bug in an event
Replies: 10
Views: 16045

Re: TM1RECALC bug in an event

Same issue in my company.

Updating Office 2010 to SP1 and TM1 9.5.2 to FP1 doesn't help either.
Going back to previous Excel or TM1 versions can't be the only way out.

I've just sent a new bug report to our TM1 service provider...
by Ben Stremme
Tue Aug 09, 2011 7:11 am
Forum: Bugs
Topic: PM33830 Macro function TM1RECALC1: ScreenUpdating handling
Replies: 6
Views: 9139

Re: PM33830 Macro function TM1RECALC1: ScreenUpdating handli

We use to work with the german version. But the ScreenUpdating behavior is exactly the same when working with the english version of Excel. The problems I'm facing are definitely caused by the source code in tm1p.xla. IBM considers the removing of "Application.ScreenUpdating = True" at the...
by Ben Stremme
Thu Jul 28, 2011 9:40 am
Forum: Bugs
Topic: PM33830 Macro function TM1RECALC1: ScreenUpdating handling
Replies: 6
Views: 9139

Re: PM33830 Macro function TM1RECALC1: ScreenUpdating handli

I just implemented lotsarams proposal. Even though the "please wait shape" is displayed, the screen still flickers during the execution of "TM1RECALC". For some instants you still see the sheet changing to the original report surface and back. The speed issue isn't solved by that...
by Ben Stremme
Wed Jul 27, 2011 9:25 am
Forum: Bugs
Topic: PM33830 Macro function TM1RECALC1: ScreenUpdating handling
Replies: 6
Views: 9139

PM33830 Macro function TM1RECALC1: ScreenUpdating handling

Problem description 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 Application.Run("TM1RECALC1") is used the property "Application.ScreenUpdating" seems...