From Excel 2002 onwards, Excel supports retrieval of real-time data. The RTD architecture is more fast, efficient, reliable, and robust than the DDE architecture. Excel can be used for continuous data retrieval from applications which send updates to Excel as new data becomes available. The ScadaPro system supports retrieval of channels using channel identifiers.

To retrieve values from the local ScadaPro server in an Excel cell enter:

=RTD("ScadaPro.RTDServer",,"channel identifier") e.g.

=RTD("ScadaPro.RTDServer",,"C1")

To retrieve values from the local ScadaPro server in an Excel cell across networks:

=RTD("ScadaPro.RTDServer","server","channel identifier") e.g.

=RTD("ScadaPro.RTDServer","mypc","C1")

Disabled or error channel values are displayed as 0. If a channel does not exist, values are displayed as #N/A. If #N/A appears in the cell even though the channel exists on the current server, in Excel under Tools>Options>Security>Macro Security set the security level to Medium or Low. Then save, close and reopen the spreadsheet.

NOTE: Excel RTD across Networks requires DCOM configuration and should not be undertaken without knowledge of how to configure DCOM.