Image: Renan/Adobe Stock Updating data in a Microsoft Excel workbook is common, but you will run into cases where you can replace manual input by running a bit of M code in Power Query. This task ...

Figure B Load the Excel data into Power Query. Once you’ve disabled OneDrive, you’re ready to launch Power Query: 1. From inside the Excel workbook with all the tabs, click the Data tab. 2.