How to Copy Power Query to Another Excel Workbook

Exciting Excel Power Query Tip! 📊✨ Did you know you can effortlessly copy your queries from one workbook to another? 🔄💼 Save time and streamline your workflow with this quick trick!

Check this video about Copying Power Queries to another workbook!

Boom! Your query is now duplicated in the new workbook! 🎉

[harumih.]

How about copying query steps only to a new data, a table, in a new worksheet, assuming that the new data table is in the same format?

[esthercraft]

I have the same issue, when i copy a query steps to another workbookB, i get an expression error that it cannot find the table which was from my workbookA. I dont want to copy the table from workbookA as is huge, i just want to bring in workbookB by connection only

[katorajohnson]

I just started an entry level Accounting Position...like my first job in accounting. 😢😅 I love it but BRUH🤦🏾‍♀️😂 So point is, do you realize you just summed up in 32 seconds how much time I've been waisting...smh lol Thank you, thank you for this tutorial. #TheMoreYouKnow lol

[LinhNguyen-bqb]

Hi Jon, I tried the same step but then there is an error coming up saying Expression.Error. We couldnt find an Excel Table named 'Table3' (which is the source table I have in the other workbook). Do you know how I can fix it. Have googled but nothing works so far. many thanks!