PRoblem
XL quits with an 'Illegal Instruction' dialog in Win95
XL Bomb in MacNail
construction contract writing software
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.
|
