• Choose Edit → Links.

Notes

  • The command will only be available after your document contains links.
  • There is no easy way to tell if a document is linked into other documents.

In this command, your options will typically include:

  • Change Source: If the source (original) is renamed or moved, you must redirect the destination (link) to the new name or location.
  • Break Link: Breaking a link will paste the linked object in its current state into the destination document -- just like a normal "Copy & Paste" using Paste Special ? Values -- and updates will no longer continue.
    • In Excel, this option is available beginning in Excel 2002.
  • Update behavior: Often you will be able to select whether a link is updated automatically or manually, and (if manual update is selected) initiate an update.
  • Locking a link: This option to lock a link will prevent a link from updating until it is unlocked.
    • In Excel, this option is available beginning in Excel 2002.
  • Startup Prompt: This option will allow you to control the prompt to update links that appears when the document is opened.
    • In Excel, this option is available beginning in Excel 2002.