1 of 1 people found this helpful
In the excell vb code, select the sheet with the datalink query, then use "DlResize" to perform the update:
I seem to keep getting a compile error: Sub or Function not defined. Any tips?
EDIT: It seems that the Datalink add-in is having issues staying on, I believe that is my problem. Thank you for your solution!
EDIT 2: Turns out I was incorrect, and getting PI Datalink add-in to stay on was not the problem. There is still the same compile error.
EDIT 3: These following threads helped figure out the compile error, problem is solved