Refresh Data

About this task

After you import Historian data into an Excel worksheet, you can refresh it to get the most updated data. This feature is most useful when using relative start times, such as Now - 2h. You can also set a refresh interval to refresh data automatically.

Procedure

  1. Open the Excel worksheet into which you have imported the Historian data.
  2. Select External Data > Refresh Data
    Tip: If the External Data toolbar is not available, select View > Toolbars.
    The data is refreshed.
  3. To automatically set refresh intervals, select Data Range Properties, and provide the interval at which you want to refresh data automatically.
    Data is refreshed automatically at the interval that you have specified.