TM1 Forum

Thanks for the help. Now my code is using TM1RECALC and not TM1RECALC1 this is working well. The code calculates only the current workbook and no other and it calculates it as a whole (like the normal F9) not a sheet at time like using the Shift+F9. I've been testing it myself for the last couple of...

Thankyou for your help I'll use that in my code. From what you've said I need the TM1RECALC rather than TM1RECALC1 because I will always be calculating full book. My code is not overly complex because it is essential to calculate a complete book full. It will give unreliable results calculating each...

Hi there I am making a .xla file as an addin for our users so that they can calculate just a workbook and not all open books within Excel. I've got the code working but the calculation works intermittently and I'm not sure which is the most reliable command to use? appication.run "TM1Recalc1&qu...