Illegal Instruction

Problem

XL7 quits or bombs with 'Illegal Instruction' when making project list extraction in MacNail construction scheduling software

Diagnosis

This crash may occur when creating a schedule from aconstruction estimate in Scheduling. It also occurs in estimating (TA 568) and specwriting (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 SCHEDUL.XLM
2. Choose Go To from the Formula menu.
3. Go to cell C42.
4. Change the formula to =FORMULA("=(r["&C39&"]c[1]+r["&C39&"]c[2]+r["&C39&"]c[3])>0","r[1]c4")
5. Go to cell A1.
6. Choose Save from the File menu.

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

Comments

This is fixed in later versions.

Entered 9/18/96 by Jeremy. Updated 11/23/2010.