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:
When I select the cell, right click, and select "recalculate (resize) function", the formula changes to:
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