i use the PI Excel AddIn to implement plant data in a Excel tab.
I use the PiCalcVal() command and import quite a couple of datapoints (around 2000 tags).
I have the problem, that PI always wants to update the data (but this is not necessary). After every equation or caluclation i implement in the Excel sheet, even if the PI-data is not needed/used for this equation - PI wants to update the data.
This is really annoying, not necessary and slows down the workflow significantly.
Is there any possible option, that PI should only update the data every (for example) hours or so? I tried to increase the "Interval" value (under setting - automatic update) - but this had no impact.
Any tips how to solve this problem?
Thanks and kind regards