XL97: Links to Excel 4.0 Macro Sheets Do Not Update

ID: Q217129

The information in this article applies to:

Microsoft Excel 97 for Windows

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:

Method 1

Press CTRL+ALT+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 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: XL97 recalc recalculate xlm

Keywords : kbdta
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb