Skip navigation
All Places > All Things PI - Ask, Discuss, Connect > Ideas

Allow VBA to hide array formula Task Panes

score 1
You have not voted Submitted
Originally posted on UserVoice

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

Comments