How can we improve PI DataLink?

Support named ranges to avoid issue KB01369

Excel places named ranges in formulas when a cell has a named range (instead of cell references). Excel formulas become more readable this way.
Datalink should support defined named ranges too.
Editing a Datalink array formula directly in Excel and replacing cell references with named ranges in works already.
But Datalink pop-up dialogs can only use cell references.
With named range support for parameters of Datalink formulas no workbook and worksheet named are added to the formula anymore avoiding the issue of KB01369.

7 votes
Sign in Sign in with OSIsoft
Signed in as (Sign out)

We’ll send you updates on this idea

mjsmeenge shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in Sign in with OSIsoft
Signed in as (Sign out)
Submitting...
  • abekearl commented  ·   ·  Flag as inappropriate

    As tinklerj mentions, it is possible enter a named range in the cell directly, but since Datalink replaces it immediately, it defeats the purpose of a named range. The usefulness of named ranges is that they can be made to be dynamic to change size depending on how many points there are etc.

  • Deepa Borkar commented  ·   ·  Flag as inappropriate

    Customer would like to enter a dynamic range of tag names in the Data Item field for a Sampled Data function in DataLink. Currently, the Data Item field only takes a single tag or a specified Excel range of cells. Customer would like to add and remove tag names and use a dynamic range of tag names in the Data Item field.

  • tinklerj commented  ·   ·  Flag as inappropriate

    "Editing... directly... replacing cell references with named ranges works already" - but as soon as you recalculate/resize, all the named ranges in the formula are replaced by cell references again.

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
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED