Denial
Structural
- Jun 3, 2003
- 924
I have a quite complicated, but not particularly large, multi-sheet workbook. It has a lot of named ranges, and makes extensive use of dynamic arrays. Most of its formulae (many of which are array formulae) use cells on different sheets. Nearly all its operations are performed by executing macros.
I need to run the workbook with its calculation mode set to manual. Then some of my macros will do different things according to whether or not a recalculation is pending (indicated in the Excel environment by the word "Calculate" appearing in the status bar, and in the VBA environment by Application.CalculationState having the value xlPending rather than xlDone).
My problem with this particular workbook is that when I make a change to a cell with dependents, "Calculate" does NOT appear in the status bar (and CalculationState is not set to xlPending). Some characteristic of my workbook seems to have upset Excel in such a way as to cancel its normal behaviour.
I have reproduced this (mis)behaviour on two computers out of two tries. One computer was running Excel 2002, the other Excel 2003.
A Google search throws up many requests for assistance where Excel puts up the word "Calculate" when the spreadsheeter believes the word should not be there. What I have is exactly the opposite.
Has anyone come across this behaviour before, and (if so) what was the explanation / cure?
I need to run the workbook with its calculation mode set to manual. Then some of my macros will do different things according to whether or not a recalculation is pending (indicated in the Excel environment by the word "Calculate" appearing in the status bar, and in the VBA environment by Application.CalculationState having the value xlPending rather than xlDone).
My problem with this particular workbook is that when I make a change to a cell with dependents, "Calculate" does NOT appear in the status bar (and CalculationState is not set to xlPending). Some characteristic of my workbook seems to have upset Excel in such a way as to cancel its normal behaviour.
I have reproduced this (mis)behaviour on two computers out of two tries. One computer was running Excel 2002, the other Excel 2003.
A Google search throws up many requests for assistance where Excel puts up the word "Calculate" when the spreadsheeter believes the word should not be there. What I have is exactly the opposite.
Has anyone come across this behaviour before, and (if so) what was the explanation / cure?