This Excel workflow turned my PowerPoint presentation into a live report

Published Nov 9, 2026, 5:01 PM EST Tony Phillips is a senior author at How-To Geek with over a decade of experience working with documents, data, and digital productivity tools. Holding a dual-honors degree in Linguistics and Hispanic Studies, he combines technical expertise with a passion for making complex topics easy to understand. Before joining How-To Geek in 2024, Tony worked as a document producer, data manager, legal document specialist, and content creator. He has also proofread and edited more than 3 million words of academic and professional writing. While Tony specializes in Microsoft 365, particularly Excel, his interests extend far beyond Office. He enjoys testing software, exploring open-source projects, discovering useful companion apps, and finding ways to customize and optimize Windows. Whether he's building spreadsheets, evaluating new tools, or uncovering hidden features, Tony enjoys helping readers get more from their technology. Outside of tech, he enjoys spending time with his dog, watching football, astrophotography, gardening, and golf. Every week, I'd receive another Excel report that eventually had to make its way into a PowerPoint presentation. Then came the repetitive part: combining the latest figures with previous data, updating my charts, and making sure the slides reflected the changes. None of those tasks were particularly difficult, but they were easy to forget and tedious to repeat. Eventually, I realized I could combine two Microsoft 365 features I was already using: Power Query's ability to import data from a folder full of files and PowerPoint's ability to display linked Excel charts. The result is a reporting pipeline where Excel handles the data and PowerPoint handles the presentation. Instead of rebuilding charts every time a new file arrives, I only need to update the weekly reports and let the rest of the process flow through the connection I've already created. Start with a folder Let Power Query collect the reports My workflow begins with a folder containing weekly Excel reports. Each workbook follows the same structure, using the same worksheet name and identical column headings. Instead of opening every report and manually copying the data into a master workbook, I connect Power Query to the folder itself. Using Data > Get Data > From File > From Folder, I select the folder and let Power Query combine the files into a single dataset. The first time I tested this setup, keeping the weekly workbooks consistent turned out to be the most important part. As long as the reports used the same worksheet names, column headings, and layout, Power Query combined them without any trouble. Once the query is set up, I don't need to rebuild it each week. At this point, I've stopped consolidating the weekly reports by hand. Instead, Power Query combines the workbooks in the folder whenever I hit Refresh, giving me a single dataset to work from. Summarize the data Build a PivotTable and PivotChart The combined dataset gives me all the information I need, but charting the raw Power Query output wouldn't make much sense. Each weekly workbook contains multiple sales records, so a chart based directly on the imported data would quickly become cluttered. Instead, I created a PivotTable that summarizes revenue by source workbook. This turns dozens of individual transactions into a much simpler view of my weekly results. For my example, I placed "Source.Name" in the Rows area and "Revenue" in the Values area. The PivotTable then calculates the total revenue from each weekly report automatically. Once I had the summary in place, I inserted a PivotChart based on the PivotTable. This gives me a clean visual showing how revenue changes from one report to the next, without overwhelming the chart with individual sales records. To clean the chart up further, I went to PivotChart Analyze > Field Buttons > Hide All. The nice thing about this setup is that I don't need to rebuild the PivotTable whenever a new report arrives: a quick Refresh All updates the Power Query results, the PivotTable, and the PivotChart together. There are a couple of settings worth knowing about: If you want Excel to check for new files automatically, click Queries & Connections in the Data tab, right-click the query, click Properties, and enable Refresh data when opening the file or Refresh every X minutes. These settings only control when Power Query refreshes. If you're summarizing the imported data with a PivotTable, I'd also clear Enable Background Refresh in the same dialog. In my testing, that ensured a single Refresh All updated the imported data, PivotTable, and PivotChart together. Otherwise, I sometimes needed to refresh twice before the chart reflected the latest data because the PivotTable updated before the query had finished refreshing. Bring PowerPoint into the workflow Link the chart instead of copying it In my old workflow, the PivotChart was where things ended. I'd copy it into PowerPoint, tweak the formatting, and move on. The catch is that a standard paste creates a snapshot of the chart. As soon as the data changes, the version in PowerPoint starts drifting away from the version in Excel. To avoid that, I copy the PivotChart from Excel and use Paste Special > Paste Link > Microsoft Excel Chart Object in PowerPoint. This creates a connection between the presentation and the source workbook. As a result, when the link is refreshed, PowerPoint pulls the updated chart from the source workbook. In practice, that means updating the workbook, saving it, and then refreshing the link in PowerPoint. In my testing, linked charts behaved more reliably when the source workbook was stored in a local folder rather than the cloud-synced OneDrive location I initially used. If PowerPoint can't find the source workbook, the link won't update, so it's worth checking the link source and file location if you run into problems. Once PowerPoint can find the workbook, refreshing the link is a lot easier than rebuilding or replacing charts by hand. Add a new report Watch the workflow update itself This is where the whole setup starts to feel worthwhile. My presentation currently contains a chart based on three weekly reports. When Week 4 arrives, I drop the new workbook into the same folder, open my reporting workbook, and click Refresh All. Excel refreshes the Power Query connection, updates the PivotTable, and refreshes the PivotChart. After saving the workbook, I open the linked PowerPoint presentation and click Update when prompted. The updated chart appears on the slide without me having to rebuild it. Instead of maintaining the same information in multiple places, I've created a reporting pipeline that looks like this: Folder → Power Query → PivotTable → PivotChart → PowerPoint Slide Once that chain is in place, the presentation feels much more like a live report than a collection of static charts and screenshots. My presentation follows the data I still need to create, download, or receive the reports themselves. In my case, that's the one part of the process that isn't automated. What this setup does remove is much of the work that happens afterward. When the spreadsheet and presentation are connected to the same reporting pipeline, there's less chance of them drifting apart as the data changes. For me, the biggest win is spending less time maintaining reports and more time using the information they contain.