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
Open the Excel worksheet into which you have imported the Historian data.
Select External Data > Refresh Data
Tip: If the External Data toolbar is not
available, select View > Toolbars.
The data is refreshed.
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.
