Brian McKeon

My feedback

  1. 9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    EVALUATING  ·  4 comments  ·  PI DataLink » Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Brian McKeon commented  · 

    In response to Jeremy Tinkler, ""Editing... directly... replacing cell r..."
    older versions didn't do this, some where around 2017 they decided to "reinterpret" your cell references and overwrite your formula where older datalinks did not. For instance, I am dealing with this nasty "Microsoft is Waiting on OLE issue" using Calculated Data to find a Maximum. However, if i delete the absolute reference in the formula bar and CTL-SHIFT-ENTER to maintain the array I can query all the data I want without getting the error. If I click the range of data in the Calculated Data Tab, EVERY SINGLE ENTRY makes me click ok, and thats a pain on 47 tags. Not going to deal with that for 1000 metering tags which is why I find more and more reasons to use C# and AF SDK so I never have to use datalink for anything.
    Long story short, the Cell references in the formula bar are over written by the calculated data module with the cellular range, but for some reason it seems to magically work again without throwing the OLE issue. I wish the module would not over write our manually created formula like the old days. I can't see why it is a "feature" to overwrite the user hard coded excel arrays.

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status