Article ID: 930479 - View products that this article applies to.
When you open a workbook that contains Dynamic Data Exchange (DDE) links to a remote source in Microsoft Office Excel 2007, the DDE links are not automatically updated. Additionally, you may receive the following message:Note If you click Update Values in the Edit Links dialog box, the links are not automatically updated the next time that you open the workbook.
This issue may occur if one of the following conditions is true:
To resolve this issue, use one of the following methods to update the links in the workbook, as appropriate for your situation.
Note You may have to close and then reopen the workbook when you use some of the following methods.
Method 1: Manually update the linksTo manually update the links in the workbook, follow these steps:
Method 2: Set the links to update automaticallyIf you receive the security warning message that is mentioned in the "Symptoms" section, follow these steps:
Method 3: Change the startup prompt for the workbookTo change the startup prompt for the workbook, follow these steps:
Method 4: Enable the automatic update for data connections or workbook links in the Trust CenterTo enable the automatic update for data connections or workbook links in the External Content section of the Trust Center, follow these steps:
Contact us for more help
Connect with Answer Desk for expert help.