I want to know if you can automatically update Excel tables and graphs. Alternatively, is there a table you can create in ProcessBook that updates automatically?
In PI Datalink, you should be able to have your spreadsheets update automatically thanks to the automatic update feature:
(volatile functions include the current value function as well as the Now() and Today() functions)
Note that you can also insert an excel spreadsheet in a ProcessBook display and have it update automatically in that ProcessBook display. You can achieve this by linking the spreadsheet:
You can update settings for linked objects in the Edit > Links window:https://livelibrary.osisoft.com/LiveLibrary/content/en/processbook-v3/GUID-A2116CE6-2EAD-463A-8638-722085FA2E89
For Context, I have created a chart in excel that uses a Pi tag as the information source. To retrieve this information i have used the "compressed data" option in the PI toolbar and set it to receive a number of values, counting backwards in time from time " * " (current time) This data is then used in a formula to produce values such as the mean, min and max which is then used as the data values for my chart.
I think what you are saying about linking the Excel object instead of embedding it is part of the answer, however this still has a few issues.I have noticed a few things in trying to update this chart. Firstly the automatic update feature that you mentioned above does not actually work. I'm not sure why but that is the case. Secondly, trying to manually update doesn't work either (this button here -->)
The only way I can figure out how to update the data is to go back into the array that is created (using the "compressed data" toolbar that pops up) and hitting apply again.
Retrieving data ...