1 of 1 people found this helpful
In PI Archive Values Datalink function you cannot select more than one timestamp, so I would recommend you use the PI Timed Data Datalink Function which allows you to select the multiple timestamps and it will be given the same result like Archive values (Exact Time). Check the link PI DataLink for more details about Timed Data Function
Thank you Kumar for the quick answer. ''Timed Data'' PI function is indeed a solution but not quite: assuming I will need to oversize the array because the number of cells referred to as timestamps isn't static, Excel will still generate a few error messages (''The time is invalid'').
The timestamps are generated, using PiCompDat, which will change depending on the set start and end time (using a dynamic excel function like NOW() ).
I'd prefer not having to filter out the error messages (in order to draw a graph e.g.) because It will also hide other relevant information in the sheet.