XL2/XL3: Function Macros Don't Update When Macro Code Is ChangedLast reviewed: February 2, 1998 |
The information in this article applies to:
SUMMARYWorksheet values returned by custom function macros in the versions of Microsoft Excel listed above are not automatically updated when you make changes to the function macro code. MORE INFORMATIONFunction macros are read into memory as each equation calling the macro is entered into a spreadsheet cell. To update cells that call a function macro that has been edited, you must reenter the equations in those cells. To update a function macro in a single cell, follow these steps:
The formula will be entered on the spreadsheet and the function macro will be recalculated. To recalculate all cells that refer to a function macro, follow these steps:
This will reenter all formulas that contain a reference to the edited function macro and update spreadsheet values accordingly. REFERENCES"Microsoft Excel User's Guide," version 3.0, pages 572-574 |
Additional query words: 2.1 2.10 2.2 2.20 2.21 3.0 3.00 XL3 XL2 calculate Last reviewed: February 2, 1998 |