AnsweredAssumed Answered

Resizing

Question asked by williaer on Apr 12, 2017
Latest reply on Apr 14, 2017 by jyi

Hi Folks,

 

I'm having a bit of a problem with the resize function in the excel datalink. I have a formula that's inserted into a cell as part of a VBA code:

=PISampDat(Macro!$D$1,Macro!$B$2,Macro!$B$3,Macro!$B$4,0,)

 

 

When I select the cell,  right click, and select "recalculate (resize) function", the formula changes to:

=PISampDat(Macro!$D$1,Macro!$B$2,Macro!$B$3,Macro!$B$4,1,)

 

This ends up displaying the timestamp and writing over adjacent columns, and is less than helpful... I've tried resizing using DLresize, but when I do, I get an error: "Active cell does not contain Datalink formula"

 

Any thoughts on why this might be happening? I'm running Excel 2013, and PI Datlink 2013 V5.0.0

Outcomes