ExcelStarter
New member
- Joined
- Jan 23, 2018
- Messages
- 27
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Changing parameters and then loading does not automatically refresh them.
Last edited:
Parameter change(not refresh)
- Thread starter ExcelStarter
- Start date
Changing parameters and then loading does not automatically refresh them.
horseyride
New member
- Joined
- Nov 24, 2017
- Messages
- 104
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365 Pro Plus 1708.8431.
View attachment sample.xlsx
Create a named range Table3 with Column header Parameter and the actual parameter below that; reference the value in Powerquery using Excel.CurrentWorkbook(){[Name="Table3"]}[Content]{0}[Parameter]
Create a named range Table3 with Column header Parameter and the actual parameter below that; reference the value in Powerquery using Excel.CurrentWorkbook(){[Name="Table3"]}[Content]{0}[Parameter]
Code:
let Source = Excel.CurrentWorkbook(){[Name="List"]}[Content],
ChangeType = Table.TransformColumnTypes(Source,{{"list", type text}}),
Parameter = Excel.CurrentWorkbook(){[Name="Table3"]}[Content]{0}[Parameter],
FilteredRows = Table.SelectRows(ChangeType, each (
[list] = Parameter))
in FilteredRows
Last edited:
ExcelStarter
New member
- Joined
- Jan 23, 2018
- Messages
- 27
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Thank you for your reply.
Could you tell me why it is not refreshing?
Could you tell me why it is not refreshing?