Is there any way Programmatically Recalculate (Resize) Notification Results in Excel using Macro?
Please refer to KB01035 and let me know if this is what you're looking for.
The article walks you through creating a button that will automatically resize all DataLink arrays in your workbook and includes a sample Excel file as an example.
Thank you for the response. I had referenced this article and it works fine for PI DataLink.
However when I try to use it for resizing PI DataLink Notification results
I get the error
"The given key was not present in the dictionary" if I set the addin to Set addIn = Application.COMAddIns("PI DataLink")
and the error
"Object Variable or With Clock not set" if I set addin to Set addIn = Application.COMAddIns("PI DataLink Notifications")
Retrieving data ...