Summary
It is possible to copy a Power Query query from one file to another. To do this, select the query that needs to be copied, right-click on it and choose Copy. Then, open the destination file, go to Data > Get & Transform > Show Queries, right-click on the text editor area and select Paste.
1
Alternatively, one can use the PowerQuery Add-in to copy the query, open the Excel workbook, and paste it into the new workbook.
2
3
According to
See more results on Neeva
Summaries from the best pages on the web
Summary
STEP 1 : Open the workbook with the existing query.
Go to Data > Get & Transform > Show Queries
STEP 2: In Workbook Queries, right click on the Table1 Query and select Copy .
STEP 3: Jump over to the workbook that does not have this query yet.
Go to Data > Get & Transform
Copy and Paste Queries In Power Query | MyExcelOnline
myexcelonline.com
Summary
This article provides a step-by-step guide on how to share a query with others or use it in a different Excel workbook. It explains how to use the PowerQuery Add-in to copy the query, open the Excel workbook, and paste it into the new workbook. Don Tomoff is passionate about helping professionals and organizations keep up and adapt to the changing business world, and offers tips, tricks, and efforts to increase productivity.
Sharing PowerQuery Queries Between Excel Workbooks - Medium
medium.com
