Can you share the Excel file? -- No. Sorry. There are "hundreds" of formulas inside. The beginning of the chain looks like this:
D5 =C34 C34 =SUM(A8:A13) A8 =IFERROR(SUM(B22);0) A9 "is empty" A10 =SUM(B24) A11 "is empty" A12 =SUM(B26) A13 "is empty" B22 =SUM(D12:F12) B24 =SUM(D14:F14) B26 =SUM(D16:F16) D12 =SUM(D30:D40) E12 =IF(H9="Yes";MAX(E18-(J18-J20)*SheetA!B2;SheetA!C2);MAX(E18-(J18-J20)*SheetA!F3;SheetA!F3)-IF(E9>0;F59;0)) F12 =F228/(D458+E58)*(D82+E82) D14 =IF(H54>0;D40/H40/I40/J40*H64*I64*J64;0) E14 =E40/H40*H64+E40/J40*(J64-J40)*0,3 F14 =F40/(D40+E40)*(D64+E64) D16 =IF(H66>0;D42/H42/I42*H66*I66;0) E16 =E32/H32*H66+E42/J42*(J66-J42)*0,3 F16 =F42/(D42+E42)*(D66+E66) etc -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-How-to-update-excel-file-with-many-formulas-tp5728410p5728412.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
