philfer
11-13-2008, 07:54 AM
Hello,
When excel autorecalculates is there a way either in excel or programatically to see list which formulae are being recalculated and in what order.
The reason I am trying to get this type of "call stack" is I am working on a workbook that is large and slow.
I am trying to eliminate the volatile functions to slim it down but I really want to see why it keeps recalculating so often i.e. whenever I move from one sheet to another it recalcs, and I am losing the will to live!!!
Thanks for your help
Phil
When excel autorecalculates is there a way either in excel or programatically to see list which formulae are being recalculated and in what order.
The reason I am trying to get this type of "call stack" is I am working on a workbook that is large and slow.
I am trying to eliminate the volatile functions to slim it down but I really want to see why it keeps recalculating so often i.e. whenever I move from one sheet to another it recalcs, and I am losing the will to live!!!
Thanks for your help
Phil