Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there any way around the maximum of seven nested functions? | Excel Worksheet Functions | |||
lookup more than one cell | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
find maximum of two values in an array with same lookup value | Excel Discussion (Misc queries) |