Microsoft KB Archive/218755

= Links to Excel 4.0 Macro Sheets Do Not Update =

Article ID: 218755

Article Last Modified on 8/18/2005

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q218755



SYMPTOMS
When your workbook recalculates, certain cell links are not updated.



CAUSE
Links to Excel 4.0 macro sheets do not update during normal calculation.



WORKAROUND
To work around this behavior, use either of the following methods.

Microsoft Excel for Windows:
Press CTRL+ALT+F9 to perform a full recalculation.

Microsoft Excel for the Macintosh:
Press COMMAND+SHIFT+F9 to perform a full recalculation.

Method 2
Move your source data from Excel 4.0 macro sheets onto a worksheet.



MORE INFORMATION
In all versions of Microsoft Excel, Excel 4.0 macro sheets are designed to store XLM-style macros, functions, and dialog boxes. Excel does not calculate macro sheets like normal worksheets. Excel calculates formulas in macro sheets one formula at a time, and only calculates when you run the macro or custom worksheet function on the macro sheet. Also, macro sheets are not part of the worksheet calculation dependency chain in Excel, and any formula links to cells on macro sheets are not updated during normal recalculation.

Additional query words: XL recalc recalculate xlm XL

Keywords: kbprb KB218755

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.