Microsoft KB Archive/71090

{| = UAE Editing Function Macro with Manual Calculation in Excel =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q71090

SUMMARY
If Manual Calculation is enabled and you edit a function macro in a spreadsheet with the Formula Replace command, you will receive an Unrecoverable Application Error (UAE). In Excel for OS/2, a system violation error results. If Automatic Calculation is enabled, this error does not occur.

Steps to Reproduce Problem
 Open a spreadsheet and a macro sheet. Change the spreadsheet's calculation to manual by choosing Calculation from the Options menu, selecting Manual and pressing ENTER.  Enter the following on the macro sheet: A1: plusone              B1: plustwo A2: =ARGUMENT(&quot;number&quot;)  B2: =ARGUMENT(&quot;number&quot;) A3: =RETURN(number+1)    B3: =RETURN(number+2)  Select cell A1 on the macro sheet. Choose Define Name from the Formula menu, activate the Function button and choose OK. Follow the same steps for cell A2.  On the spreadsheet, enter the following: A1: 1          B1: =macro1!plusone(A1) A2: 2          B2: =macro1!plusone(A2)

Cells B1:B2 will now display 2 and 3.  Select B1:B2 and choose Replace from the Formula menu. Type &quot;one&quot; in the Find What edit box and &quot;two&quot; in the Replace With edit box (without the quotation marks). Press ENTER and a UAE or System Violation error results.

Workaround
This error does not occur when Calculation is set to Automatic. If Calculation is set to Manual you can bypass the error message by applying the Formula Replace command to the cells one at a time.

Microsoft is researching this problem and will post new information here as it becomes available.
 * }