Illegal Instruction

Problem

XL Bomb in MacNail construction contract writing software. Excel quits with an 'Illegal Instruction' dialog in Win95.

Diagnosis

This crash may occur when creating a contract directly from a MacNail Estimate. It also occurs in estimating (TA 568) and scheduling (TA 571) when making project lists.
Basically, XL dies trying to run the extraction-- it no longer accepts SUM as a criteria.

Solution

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

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

Comments

Entered 9/18/96 by Dennis. Updated 11/25/2010.