Triggered recalculation

Excel recalculates volatile functions, and any function or chart that references a volatile function, whenever you edit any worksheet cell or press F9. Volatile functions include the Excel time functions, now() and today(). The Current Value function is a volatile function; other PI DataLink functions are not. You can trigger recalculation of non-volatile PI DataLink functions by referencing a volatile function within the non-volatile PI DataLink functions.