https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/24869&feed=atom&action=history
Microsoft KB Archive/24869 - Revision history
2024-03-28T21:45:44Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/24869&diff=136780&oldid=prev
3155ffGd: importing KB archive
2020-07-18T16:14:16Z
<p>importing KB archive</p>
<p><b>New page</b></p><div>{|<br />
|width="100%"|<br />
== Excel: Cell Doesn't Update If Worksheet Linked to Macro Sheet ==<br />
|}<br />
<br />
<br />
-----<br />
<br />
The information in this article applies to:<br /><br />
<br />
<br />
* Microsoft Excel for the Macintosh, version 1.x, 2.2, 3.0, 4.0<br />
<br />
<br />
-----<br />
<br />
<br /><br />
<br /><br />
<br />
<br />
== SUMMARY ==<br />
<br />
<br /><br />
<br /><br />
When using an external link on a worksheet to refer to a cell on a macro sheet, the worksheet cell will not update (even when the macro sheet is updated) if the worksheet cell is not forced to recalculate.<br /><br />
<br /><br />
Macro sheets are calculated only when a macro is executed, and then only one cell after another, down a single column [unless a GOTO(), RETURN(), HALT(), or RUN() command or user-defined function is called].<br /><br />
<br /><br />
If the worksheet cell containing the external reference is forced to recalculate in some manner, the cell receives the latest information. The worksheet will not be recalculated because of a change on the macro sheet to which it is linked. An external link to a macro sheet is not recommended for maintaining a hot link.<br /><br />
<br /><br />
<br />
<br />
Additional query words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00 4.00 calculate<br />
<br />
Keywords :<br /><br />
Version :<br /><br />
Platform :<br /><br />
Issue type :<br /><br />
Technology :<br />
<br />
{|<br />
|width="100%"| <br /><br />
Last Reviewed: March 16, 1999<br /><br />
<span>© 2000 Microsoft Corporation. All rights reserved. Terms of Use.</span><br /><br />
|}</div>
3155ffGd