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