Skip navigation
All Places > All Things PI - Ask, Discuss, Connect > Ideas

Support named ranges to avoid issue KB01369

score 6
You have not voted Submitted

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.