#NUM! error for long formulas


#1

Hi

I’m getting #NUM! excel errors when creating very long formulas. For example,

=AD14+AI14+AN14+AS14+AX14+BC14+BH14+BM14+BR14+BW14+CB14+CG14+CL14+CQ14+CV14+DA14+DF14+DK14+DP14+DU14+DZ14+EE14+EJ14+EO14+ET14+EY14+FD14+FI14+FN14+FS14+FX14+GC14+GH14+GM14+GR14+GW14+HG14+HL14+HV14+IA14+IF14

would give me an error once the spreadsheet has been generated. However, if I hit F2 in cell with the #NUM! error afterwards, the error is gone and everything is fine.

I’m currently using 1.6.2 and I’m not sure if this has been fixed for later versions. This version is currently in production so I would prefer not to upgrade the production version unless it is absolutely necessary.

Thanks,

Steve


#2

Hi Steve,

I will fix this problem ASAP. Thanks for your patience.