Entering Values of a horizontal Range in Another Worksheet

[Snake Eyes]

I'm trying to have a worksheet display the values of 6 horizontal cells from another worksheet in the same workbook and in order as they appear.
I've created a Named Range "ExecutedTotals_2023_Jan" for these cells.

Instructions say...
To display a named range on another sheet, you just need to use the formula =name (the range name) and press Shift + Ctrl + Enter keys together.

If I do this in the first of 6 cells or if I select all 6 horizontal cells and do this and I get #NAME in either the one cell or all 6 cells.
What am I missing?

 

[Sufiyan97]

in which version of excel you are using this?

if you type =<name> which you have choose for your range, does it show in dropdown?

 

[Fluff]

If you are doing this in 365 you just need to use

=ExecutedTotals_2023_Jan

 

[Snake Eyes]

I'm using 365 and when I use

=ExecutedTotals_2023_Jan

I get #NAME? and a cell warning saying "The formula contains unrecognized text."
The five cells to the right I expect to have data from the range are blank.

This does work if I use it on the same worksheet that contains the range.

 

[Fluff]

That means the defined name is worksheet scope, so you will need to put the sheet name infront like

='Sheet 1'!ExecutedTotals_2023_Jan

 

[Snake Eyes]

As usual, Fluff with the answer.
Thanks...... again, Fluff.

 

[Fluff]

Glad to help & thanks for the feedback.