using Named Range in Power Query

[Scott R]

I'm putting a filename from a named range into my Query (variable FN) but it doesn't seem to refresh in the Query even though the value has changed in the Worksheet.
If I Refresh Preview, the value changes but why doesn't it use the most recent entry in 'BOARD_fn' with a Refresh All?
Is there a step needed to refresh FN? Guess I thought Refresh All would do that.

let
FN = Excel.CurrentWorkbook(){[Name="BOARD_fn"]}[Content]{0}[Column1],
Source = Excel.Workbook(File.Contents(FN), null, true),

 

[GraH]

I think your FN variable returns a list, not a single value.
Please try like this.

FN = Excel.CurrentWorkbook(){[Name="BOARD_fn"]}[Content]{0}[Column1]{0},
   Source = Excel.Workbook(File.Contents(FN), null, true),