Querying Alarm and Event Data in the Excel Add-In
Procedure
- From the Historian menu, choose Query Alarms & Events. The Query Alarms & Events dialog appears.
- Select a Server. Your default server should be selected. To set the selected server as default, ensure the Set Server to Default option is enabled.
- Select from Query Type.
- Select a Query Criteria.
- Select your Output Display and Sorting.
- Click OK.Note: Excel limits the amount of data that can be entered into a formula or returned into a worksheet. The following are guidelines for formula and result limits in various versions of Excel. Output is limited to:
- Excel XP: 32767 cells
- Excel 2003 32767 rows