Forum Discussion
a68tbird
Resolver II
Resolver IIReferencing an Excel Sheet Without Using Name
Hello All, I'm trying to summarize a folder of Excel invoices, and have done this quite a few times before with an invoked function call, but have run into this problem for the first time, hoping ...
Add this line. It will get the first sheet regardless of its name.
= Table.SelectRows(Source, each [Kind] = "Sheet"){0}[Data]Do that right after the SOURCE line that shows all objects in the file. You'll probably need to delete the default NAVIGATION step Power Query does.
edhans
Community Champion
Community ChampionAdd this line. It will get the first sheet regardless of its name.
= Table.SelectRows(Source, each [Kind] = "Sheet"){0}[Data]Do that right after the SOURCE line that shows all objects in the file. You'll probably need to delete the default NAVIGATION step Power Query does.
a68tbirdThanks very much! That worked perfectly!