PQ Helper

How do I save and reuse Power Query queries and functions? Download: https://www.eloquens.com/tool/MkGJS4M3/finance/excel-tips/bxl-pq-helper-import-export-power-query-functions-and-queries I found this question back in 2015 on Microsoft's TechNet forum. The answer really didn't address reuse. I had the same need, so I created my own tools to import/export functions and queries as well as manage connections. Then in Dec. of 2021, a forum poster asked how to, with VBA, import a query, run it, then delete it so the workbook wouldn't open with the dreaded SECURITY ALERT! The tools I created back in 2015 addressed his needs. So I decided to update my tools and give them to the forum poster - and while I was at it, give them to all my Excel friends as a Christmas gift. While this was designed initially for my own use as a VBA developer, it is also useful for non-VBA users as it does things more efficiently than what Microsoft offers natively in Excel. One example is Power Query functions are spread across two of Excel’s ribbon tabs: Data and Queries. This tool places them in one place along with BXL enhancements. A BXL enhancement is importing queries. This tool loads as many as we can select – all at once. Excel’s Queries & Connections icon (on Data tab) only loads one at a time. Another enhancement is this tool’s ability to show and delete all connections. Excel’s Queries & Connections pane, Connection tab doesn’t show all and only allows deleting one at a time. If we want to clear all connections, we really need this tool for that. So, if our client only needs the data we loaded using Power Query, we can use this tool to remove all queries and all connections and avoid the dreaded SECURITY ALERT! BXL: Beyond Excel https://sites.google.com/site/beyondexcel/home/add-ins/bxl-pq-helper