Illegal Instruction

Problem

XL7 quits or bombs with 'Illegal Instruction' when making project list extraction.
only in Win95??

Diagnosis

This crash may occur when making a project list with titles in MacNail construction estimating software. It also may occur in scheduling (TA 571) and specwriter (TA 572)

Basically, XL dies trying to run the extraction, since it now chokes on having a SUM formula there, for some reason.

Solution

1. Open the ESTIMATE.XLM
2. Choose Go To from the Formula menu.
3. Go to cell H103.
4. Change the formula to =FORMULA(IF(include.titles,
" =(r["&H99&"]c[1]+r["&H99&"]c[2]+r["&H99&"]c[3])>0",">0"),"r[1]c4")
5. Go to cell A1.
6. Choose Save from the File menu.

Old formula:
=FORMULA(IF(include.titles, "=sum(r["&H99&"]c[1]:r["&H99&"]c["&IF(version<3,4,3)&"])>0",">0"),"r[1]c4")

Comments

Entered 8/23/96 by Jeremy. Updated 11/17/2010.