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.
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
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.
"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.