Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Cannot Set Edit Links to Manual for Workbooks

View products that this article applies to.


You cannot use the Links dialog box to change the Update setting to Manual for an Excel workbook.

↑ Back to the top


The Manual option in the Links dialog box only changes the Update setting for the following objects linked into the workbook:
  • Embedded objects (such as a Microsoft Word document that is linked into a workbook)
  • OLE objects
  • Dynamic Data Exchange (DDE) objects

↑ Back to the top

More information

You cannot use the Links dialog box to make links to other Microsoft Excel workbooks be updated manually. Linked Excel workbooks are always updated automatically when Excel calculates the workbook.

To see the Links dialog box, click Links on the Edit menu.

↑ Back to the top

Keywords: KB259558, kbprb

↑ Back to the top

Article Info
Article ID : 259558
Revision : 4
Created on : 9/25/2003
Published on : 9/25/2003
Exists online : False
Views : 259