Speed up Power Query with List.Buffer. Cache lists, cut recalculation, and slash refresh times for large datasets in Excel and Power BI.

This guide describes how to reorder multiple columns in Power Query with Drag & Drop, without having to move each column individually.

To enable automatic updates, simply refresh the Power Query connection to your folder. Excel will scan the folder for any new files and seamlessly integrate them into your existing dataset.

If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.