The information in this article applies to:
- Microsoft Excel for Windows, versions 3.0, 4.0, 5.0
SUMMARY
There are recalculation problems with function macros in the versions of
Microsoft Excel listed above that are not present in Microsoft Excel
version 2.1.
MORE INFORMATION
The Microsoft Excel versions above have problems recalculating function
macros arranged in a columnar fashion.
Steps to Reproduce Problem
- Open a new macro sheet and a new worksheet.
- With the macro sheet active choose Define Name from the Formula
menu. Set "z" (without the quotation marks) to zero.
- On the macro sheet, type the following:
A1: =ARGUMENT("y",1)
A2: z=z+y
A3: =RETURN(z)
- Select cell A1 on the macro sheet and define the macro as a
function macro and with the name "counter" (without the quotation
marks).
- On the Worksheet, type the following data:
A1: 0 B1: =MOD(A1,2) C1: =Macro1!counter(B1)
A2: 0
A3: =MOD(A2,2)
A4: =Macro1!counter(A3)
- Cells A4 and C1 are counters. They display how many times cells A3
and B1 have equaled zero. Both should show zero at this time.
- Put the number 1 in cell A1; notice C1 equals 1. Again, reenter
the number 1 in cell A1. Now, C1 equals 2. This is working correctly.
- In cell A2, type the number 1. Cell A4 updates correctly to 3.
- Reenter the number 1 into cell A2, cell A4 does not update. This is
the problem.
Notice that if you reenter the number 1 into cell A1, C1 does update to the
number 4. The problem only occurs when the data is aligned in columns.
Excel notices that the number in cell A3 does not need to change, and
therefore cell A4 is not updated.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post more information here in the Microsoft Knowledge Base as it
becomes available.
|