Hi, if have a performance problem with a spreadsheet document. The document has about 100 sheets and about 50.000 SVerweis() formulas as
=WENN(ODER(ISTLEER(E6);E6="");"";SVERWEIS(E6;Code.$B$4:$F$3492;2;0)) =WENN(ODER(ISTLEER(E7);E7="");"";SVERWEIS(E7;Code.$B$4:$F$3492;2;0)) ... If one enters a value in a cell of the code range, it takes about a minute on a 3 GHZ XP machine with 1 GB RAM to recalc ... My Question: Is there an analysis tool, where i can find the formulas which are involved during the recalc operation ? If have the feeleing, that the SVerweis() formulas are recalulated even if the result of the abouve =IF() statement is TRUE (-> "") ... Any hints how to speed up such large documents ? Oliver -- "Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ... Jetzt GMX TopMail testen: www.gmx.net/de/go/mailfooter/topmail-out --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
