Forum Discussion
Solved
Referencing 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.
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.
Thanks very much! That worked perfectly!
