Support named ranges to avoid issue KB01369

Idea created by Martin Smeenge on Aug 15, 2017
    Submitted
    Score7

    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.