Data validation fails with named range of array of constants

Hi all,

I've set up a Named Range that refers to an array of constants, e.g. MyRange ={1,2,3,4,5}. This appears to be fine since I can output the named range to a range of cells in a row (e.g. A1:E1) and see 1,2,3,4,5 (one value in each column).

I'd like to use MyRange as the source for a Data Validation list in a cell.

Normally data validation list sources must be vertical, so I've set MyRange =TRANSPOSE({1,2,3,4,5}). This appears to be fine since I can output the named range to a range of cells in a column (e.g. A1:A5) and see 1,2,3,4,5 (one value in each row).

When I set MyRange as the source for data validation however, it resolves to an error.

Anyone have an idea why this setup doesn't work?

Workbook detailing the problem attached. Attachment 273788 NamedRangeDataValidationArrayConstansts.xlsx