F9 Calculate Now is not working

Post Reply
sagit.saul
Posts: 1
Joined: Wed Sep 21, 2011 8:36 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

F9 Calculate Now is not working

Post by sagit.saul »

Recently we upgraded the TM1 system to the 9.5.2 version. I now noticed that the option to calculate all open sheets is not working when pressing the F9 or when clicking the icon.
Btw- this function should be used only when the manual calculation option is chosen. Do you know how can this be solved?

Admin note: Moved out of Bugs. Please read http://www.tm1forum.com/viewtopic.php?f=18&t=251 before posting in that forum.
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: F9 Calculate Now is not working

Post by lotsaram »

Are you sure this isn't due to VBA code assigning F9 as a hotkey for something else? And in general are you 100% sure on this and if so can you give more detail on exactly what you think is happening.

We have recently done some very extensive testing of 9.5.2 and haven't uncovered anything similar.
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: F9 Calculate Now is not working

Post by qml »

Also, further to lotsaram's suggestions, can you test if Application.Run("TM1RECALC") works? If it does and you're not able to uncover the reason for F9 not working (the most likely reason being F9 assigned to some other macro), you could produce a workaround by creating a custom menu item or toolbar item and assigning this short macro to it, and/or even assigning a keyboard shortcut to the macro.
Kamil Arendt
Post Reply