maximum lookup functions
 

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

maximum lookup functions
 

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

maximum lookup functions
 

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

maximum lookup functions
 

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

maximum lookup functions
 

No, all manual (using ctrl-alt-shift-F9). But this what you wrote to someone
else is helping:

Likely you have a lot of volatile functions that are recalculated every time
you do something in XL. If you want some hints as to how to optimize
performance, see this white paper:
http://msdn2.microsoft.com/en-us/library/aa730921.aspx

Thanx, Amberont



"Dave F" wrote:

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

maximum lookup functions
 

I was just about to refer you to that.

Dave
--
Brevity is the soul of wit.


"amberont" wrote:

No, all manual (using ctrl-alt-shift-F9). But this what you wrote to someone
else is helping:

Likely you have a lot of volatile functions that are recalculated every time
you do something in XL. If you want some hints as to how to optimize
performance, see this white paper:
http://msdn2.microsoft.com/en-us/library/aa730921.aspx

Thanx, Amberont



"Dave F" wrote:

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