• Web queries containing parameters
• Defined names that are not used in a formula

To manage these types of links, you must edit them individually.

To ensure that automatic links to data in other programs are updated, click Options on the Tools menu, click the Calculation tab, and make sure the Update remote references check box is selected. If this check box is cleared, the Automatic option in the Links dialog box (Edit menu) is overridden for linked data sources from other programs, such as a Microsoft Word document or a Microsoft Access database.

This message appears when the source file (source file: The file that contains information that was used to create a linked or embedded object. When you update the information in the source file, you can also update the linked object in the destination file.) or source program (source program: The program used to create a linked object or embedded object. To edit the object, you must have the source program installed on your computer.) can't be opened.

Make sure the source program is available    If the source program is not installed on your computer, convert the object to the file format of a program you do have installed.

Ensure that memory is adequate    Make sure you have enough memory to run the source program. Close other programs to free up memory, if necessary.

Close all dialog boxes    If the source program is running, make sure it doesn't have any open dialog boxes. Switch to the source program, and close any open dialog boxes.

Close the source file    If the source file is a linked object, make sure someone else doesn't have the it open.

Ensure that the source file name has not changed    If the source file you want to edit is a linked object, make sure it has the same name as it did when you created the link and has not been moved. Select the linked object, and then click the Links command on the Edit menu to see the name of the source file. If the source file has been renamed or moved, use the Change Source button in the Links dialog box to locate the source file and reconnect the link.

1. In Excel, click Options on the Tools menu, and then click the General tab.
2. Clear the Ignore other applications check box.

   If this option is selected, Excel ignores requests from programs that link to Excel data by means of DDE (Dynamic Data Exchange (DDE): An established protocol for exchanging data between Microsoft Windows-based programs.) rather than OLE (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.).