Forum Discussion
Solved
How to Load data to existing worksheet (=table) without headers using Power Query (updating table)??
I so much would like to append refreshable data (Power Query) to an (existing) table. I can of course load to cell in existing worksheet, but how: a) can I do this omitting the headers (from the imp...
You cannot do this ooptennoort - any PQ query loaded to an Excel table is a full table on its own, with headers.
The way I would to it is:- Load your existing table into Power Query.
- Append it with your new data that you previously wanted to append to the worksheet.
- Load this new appended table with all of the data to a new table.
You cannot do this ooptennoort - any PQ query loaded to an Excel table is a full table on its own, with headers.
The way I would to it is:
- Load your existing table into Power Query.
- Append it with your new data that you previously wanted to append to the worksheet.
- Load this new appended table with all of the data to a new table.