TM1 Forum

I'm seeing a marked performance difference (10x) between a refresh perfomed with a manaul F9 keystroke compared with executing an Application.Calculate in VB. This is on a worksheet with ~20k dbrw statements. The F9 method is faster.

Does TM1 "intercept" F9 when entered manually and process differently? If so, can one call the TM1 refresh directly from VB?

Thanks,
-- John

Yes. Record a macro with F9 as the only keystroke, and you will see the code TM1 uses in the recorded macro. It does differ by version.

Regards

Yes TM1 will interpret F9 when entered manually you could also use the SendKeys "{F9}" .