When I make a reference to the time interval in a cell in Excel, I get the error shown in the image above ... However, by writing "1h" directly in the PI tool Datalink if it brings me the values.
Please, help... =P
It worked just fine on my machine. A brand new instance of Excel might help perhaps? I can't understand the error message but looks like it is referencing some formula related errors?
Yes, I have put exactly the same as you to extract the values ... It seems only happens in my profile but I do not know why... btw thank you for answering!
Please try to specify a root path, such as \\<Server name>, if in your data item tab you only make reference to your tag name.
See this example below in my machine:
Apart from this, the error message seems to be related to a syntax misconfiguration but I can't see anything wrong in the screenshot you sent. Please. make sure your tag name input exists in your PI Server.
Can you try to reference a different tag to test if you have the same issue ?
Good day. I can extract data but only by writing directly the interval in the corresponding field of the PI Sampled Data.
Image: referring to field in excel.
Image: referring to the corresponding field of the Sampled Data tool.
I think it is related to the question of this link:
Datalink formula error using cell references for dates
Thanks for answering! ;3
Retrieving data ...