TM1 Forum

We have a workbook with about 15 worksheets of DBRW. Typically a F9 is used for refreshing the data which takes about a minute.

I just realised that by using Ctrl-Alt-F9, the entire workbook get refreshed withing 10 seconds.

From a MS article on Excel recalculation method, Ctrl-Alt-F9 seems to be a heavier recal method. Just curious on why I can achieve a much faster response on TM1 slices using this method as compared to traditional F9.

http://msdn.microsoft.com/en-us/library/bb687891.aspx

Any clue ?

This might be because of the Excel cell Dependencies - when a cell in the spreadsheet refers to another cell in the spreadsheet. In such cases the dependent cell must be calculated after the source cell to which the depend.

Best guess is that the addin interrupts and hijacks the f9 event do to do various other things where the Ctrl +Alt +F9 is not hijacked and so runs much faster??