I have a couple of excel files that I have linked to create a power query table using the append function combining rows from all the excel files on a separate excel file. How can I write back into the respective excel files by filling the value in the power query table ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Write back from Power Query table to Excel File
- Thread starter user0X
- Start date
Appreciate if you could guide about such VBA solutionsPQ will not update the source files. You'd need a different approach such as VBA.