XL2000: Cannot Set Edit Links to Manual for Workbooks (259558)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q259558

SYMPTOMS

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

CAUSE

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

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.

Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbprb KB259558