Skip to content
Ask A Question
  • There are no suggestions because the search field is empty.

DataHub values will not update in Excel

The DataHub DDE connection is being used to read values in an Excel spreadsheet. The cell is populated with the current value when the link is added, but the cell does not continue to update unless manually updated.

The problem is most likely the result of the Excel spreadsheet configuration. Adjust the following settings within Excel to begin receiving updates:

In Excel 2003.

  1. Go to Tools ⇒ Options
  2. Check the the "Automatic" button under the Calculation group is checked, and that the "Update remote references" checkbox in the Workbook Options group is checked.
  3. Go to Edit ⇒ Links.
  4. At the bottom of this window you will see a button that says "Automatic". Make sure this is checked for each link you want to automatically update.

In Excel 2007 or Later.

  1. Go to the Office Icon (top left corner) ⇒ Excel Options
  2. Go to the Formulas section and enable "Automatic".
  3. Go to the Advanced section
  4. In the "When calculating this workbook" header, enable "Update links to other documents"
  5. Go to Data ⇒ Edit Links.
  6. At the bottom of this window you will see a button that says "Automatic". Make sure this is checked for each link you want to automatically update.
  7. Go to the Trust Center section and click the Trust Center Settings...
  8.  Do one of the following:
    1. Go to the External Content section and Enable "Enable Automatic update for all Workbook links"
    2. Alternatively, you can select "Prompt user on automatic update for Workbook links.  Each time you open Excel you must click the Options and "Enable this content" and click OK.