-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Eike,
> If all or most SVERWEIS/VLOOKUP formulas reference the range > Code.$B$4:$F$3492 then this may be due to a broadcaster performance > problem that comes into play when too many formulas listen on identical > portions of ranges. You may try to rearrange things such that those many > identical references aren't needed. this could be true, cause on another cell range (with about 15.000 cells), i replaced all formulas (written in oo basic) through a vlookup formula ... but this lead to a performance desaster ... another two performance question: is it better: - - to use NamedRanges instead of direct cell addressing inside formulas ? CODERANGE = Code.$B$4:$F$3492 =WENN(ODER(ISTLEER(E6);E6="");"";SVERWEIS(E6;CODERANGE;2;0)) - - to split calculations, e.g. from =WENN(ODER(ISTLEER(E6);E6="");"";SVERWEIS(E6;Code.$B$4:$F$3492;2;0)) =WENN(ODER(ISTLEER(E6);E6="");"";SVERWEIS(E7;Code.$B$4:$F$3492;4;0)) to F6 =ODER(ISTLEER(E6);E6="") =WENN(ISTWAHR(F6);"";SVERWEIS(E6;Code.$B$4:$F$3492;2;0)) =WENN(ISTWAHR(F6);"";SVERWEIS(E7;Code.$B$4:$F$3492;4;0)) i noticed that this will increase the file size ... thanks Oliver GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFF2c/ITiyrQM/QSkURAnCAAKCYHDkkkrNzwZAqwQ2f9MjpXuT/vwCeIYOa Hjn286zE8tN2jnM6Q9NjsKI= =SpgX -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
