Is your calculation set to automatic? Tools--Options--Calculation--Automatic?

Dave
--
Brevity is the soul of wit.


"amberont" wrote:

I have very simple lookup functions (for example:
VLOOKUP(C$36;$C$16:$N$20;$B38;FALSE)), but a lot of them (appr. 2000) in one
spreadsheet.

In my inputsheet I change a value that has consequenses for a lot of other
sheets. From these sheet calculations are made to calculate a final result.
But sometimes (that's the problem: there's no consistency in the results), if
I change the input, the final result doesn't change! I think I have used too
many lookup functions in one spreadsheet and Excel can't cope with that.

"Dave F" wrote:

The number of formulas is generally limited by available memory on your
computer.

Post one of the formulas you think is not working correctly, with an
explanation of what it is doing, and what you think it is doing. Perhaps you
are overlooking something.

Dave
--
Brevity is the soul of wit.


"amberont" wrote:

Hi!
Does anyone know how many lookup functions one spreadsheet can take to still
function properly? My spreadsheet doens't return the right numbers. Does it
help to maximize the number of iterations?

Amberont