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.
F9 Calculate Now is not working
-
- Posts: 1
- Joined: Wed Sep 21, 2011 8:36 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
-
- 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
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.
We have recently done some very extensive testing of 9.5.2 and haven't uncovered anything similar.
- 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
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