Originally posted on UserVoice

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.

# Support named ranges to avoid issue KB01369

- Comment • 3

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