F9 vs Ctrl-Alt-F9 on TM1 slices

[kangkc]

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 ?

[rkaif]

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.

[Steve Rowe]

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??