Customers have been using DLResize in the VBA pidldialogs.xla project which is unsupported. It would be nice to create a programmatic access layer so that things such as DLResize can be done in a supported way. It would also be helpful to have programmatic access to automatic update settings and automatic update on/off button.

Note: This was previously Enhancement 19897OSI8

Create a way to programmatically set the Datalink Settings so that they can automate excel reporting more effectively

Excel VBA code can invoke the resize/recalculate function on Datalink array formulae.  However this requires selection of the array and this pulls the appropriate Task Pane into view (unless the Datalink setting is in force that turns this off).  It would be good if the VBA code could hide this Task Pane, but trying to do this currently causes an exception.  See PI Square thread: https://pisquare.osisoft.com/message/116861-re-is-there-a-way-to-force-a-pi-datalink-array-formula-to-recalculateresize-using-vba-automation

Because Datalink always uses the default settings when run like a service, it'll be nice to have a programmatic way to access the Datalink settings