Links Dialog Box

The Links dialog box has the following options:

List of Links

Displays the links that exist in the worksheet.

Update Now

Updates a manual link.

Open Source

Opens the application in which the linked object was created.

Change Source

Links the object with a different source file. The new source file must have been created in the same application as the original source file.

Break Link

Breaks the link between an object's original source and the copy of the object in the worksheet.

Update

Choose Automatic so the link updates whenever you open the worksheet and any time the source information changes while the worksheet is open.

Choose Manual so the link updates only when you update it by pressing "Update Now."