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.
Search found 5 matches
- Wed May 23, 2012 9:01 am
- Forum: Bugs
- Topic: TM1RECALC bug in an event
- Replies: 10
- Views: 16045
- 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...
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...
- 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...
- 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...
- 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...