When to Use Excel Instead of the Historian Excel Add-In

Use the Excel Add-In when you want to get data into Microsoft Office 2003, 2007 or 2010 (32-bit/64-bit). Use the Historian OLE DB Provider with Excel, instead of the Excel Add-In, when you want to do any of the following:

  • Perform advanced filtering, sorting, and joining of data.
  • Obtain detailed information from the ihTrend table.
  • Run calculations using the SQL aggregate functions.
  • Perform advanced summaries.