Introduction to the DeltaV Excel Add-in

Correct #N/A values for a DVReadWithStatus function

If a DeltaV function returns a value of #N/A and the workbook is saved, closed and re-opened, the function will not automatically calculate. If the #N/A value persists after updating begins, take the following steps:

For a DVReadWithStatus function:

  1. Select the cell containing the #N/A value and the cell containing the status value.
  2. Press F2.
  3. Press CTRL+SHIFT+ENTER.
    Note

    If #N/A continues to be returned, then the parameter might not have been found. Refer to the text status value of the DVReadWithStatus function for an indication of the cause.