Forum Discussion
How to amend multiple source files by different power query
Hello all,
is there any way how to amend different source files in one XLS file ?
I have one file with 9 sheets, for every sheet I did amend power query editor.
But problem is that I need to use different source for every sheet. Now There is only 1 source file for every sheet:
Is there any way how to change source file for every sheet?
Many thanks in advance.
Hello - yes, this can easily be done. Your scripts may currently be using the Excel.CurrentWorkbook connector. This will need to be changed to Excel.Workbook and add the file name, object kind (Sheet, Table) and the object name. You can edit this in the Advanced Editor for the queries.
3 Replies
Hello - yes, this can easily be done. Your scripts may currently be using the Excel.CurrentWorkbook connector. This will need to be changed to Excel.Workbook and add the file name, object kind (Sheet, Table) and the object name. You can edit this in the Advanced Editor for the queries.
Wonderful! You are very welcome. Please accept the solution provided so this item can be closed. Thanks!