Excel recalculation

[Guest]

In a workbook with a large number of worksheets and lookup formulae I have
encountered a new problem.

In the past I've seen the problem where 'Calculate' is permanently displayed
in the Status Bar due to the dependency limit being reached, even with
automatic calculation set.

I added some additional worksheets yesterday and formulae linked between
other worksheets were not updating automatically, even when I hit F9. I had
to go into each cell individually and hit F2 then return for the formula to
update.

Has anyone seen this happen before?

Regards

 

[Guest]

Does CNTRL-ALT-F9
work any better?

 

[Guest]

Yes - all the cells recalculated. A couple of follow on questions:

Why does this (calculate all sheets in the active workbook) work but not F9
(calculate all sheets in all open workbooks)?

Have I reached some sort of iterative limit for recalculations?

Thanks

 

[Guest]

CNTRL-ALT-F9 forces total recalculation even if Excel sees no reason to do
so. If you can't get recalculation to occur automatically with the usual
mechanism (Tools>Options>Calculation), you can force it. Create an event
procedure that detects changes in cell values an issues
Application.CalculateFull in response.

Good Luck