AnsweredAssumed Answered

Clear DataLink cache with VBA code?

Question asked by MaxStrueverWipro on Feb 3, 2016
Latest reply on Nov 16, 2017 by TEL1


I was realizing there must be a cache that PI datalink uses for AF data (for non-pi-point attributes) and had been closing and reopening Excel to get the latest values (I am testing some things and changing values  in attributes without a data reference frequently and need to see them updated).

I just found the "clear cache" button in PI DataLink > Settings, which is great!


just curious, is there anyway in our own custom VBA code that we can access the Clear Cache function from within PI DataLink's functions?

Sub customFunc()
    'Clear cache for datalink before doing work??

     'PIDatalink.ClearCache() ??

    'perform calculations on super fresh data
     dim answer as integer
End Sub


I'm guessing no but it would be a nice-to-have