Base PI DataLink functions on volatile Excel functions

You can maximize the refresh frequency and keep function arrays and charts current by basing your PI DataLink functions on a volatile Excel function.

Note: To maximize the frequency of updates when Automatic Update is not in use, check your Excel calculation preferences to ensure that both the worksheet and application are set to Automatic rather than Manual calculation. Keep in mind that this might impact performance and make large worksheets difficult to use.

1. Use the Excel formula bar to enter a volatile function in a worksheet cell.

   For example, you can use (today()+1/3) to represent 8 a.m. the same day, or now() as a cell reference to replace the current PI time, *.

   To create an absolute time stamp that triggers updates, add and subtract now(), such as 2-feb-12 00:30:30 + now() - now().

2. Reference the cell when you define the Start time or End time inputs of a PI DataLink function.