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

--
R Ormerod