Refresh Excel Data
You can use the data refresh feature in Excel to update the external data that displays in the spreadsheet. When you perform the update, the current Historian data at the time of the refresh is returned with the query. The refresh feature is most useful when using relative start times, such as Now - 2h
. Excel also allows you to automatically set refresh intervals.