Excel: Links Don't Update During Manual Document CalculationLast reviewed: November 1, 1994Article ID: Q74615 |
SUMMARYIn Microsoft Excel versions 2.2 and 3.0, if manual calculation is turned on, holding down the SHIFT key and choosing Calculate Document from the Options menu will not update external references. One workaround is to use the Links command on the File menu to redefine the link. When a link is redefined, the linked values are automatically updated. To update the links in this manner, do the following:
=CHANGE.LINKS("filename","filename")Note that the old filename and the new one are the same. This command assumes that the dependent document is active.
MORE INFORMATIONExcel determines whether links need to be updated by checking a flag associated with each supporting document. The flag is normally set if changes have been made. If manual calculation is turned on, the flag is not updated, and therefore Excel cannot determine that an update is necessary.
|
KBCategory: kbother
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |