Update PowerPoint from Excel using a Database and Excel


The Client’s Quarterly Management meeting uses the same PowerPoint slide, just with updated numbers. There are many slides and, depending on the data, some new ones need to be inserted.

We created an Excel workbook that is connected to the Sales database and has the formatted charts and tables. We then took their PPT file and added ‘tags’ to each slide. Our Excel code refreshes the data from the database, loops through all the PPT slides, reads the ‘tag’ in the slide that tell it where the chart or table is, finds the updated data in Excel, and replaces the existing chart or table.

Versions of this can merge Sales and Nielsen data or compare more than one account.

Recent News

Analyze PDF Files in Excel

In today’s data-driven landscape, extracting valuable information from PDF files is a common challenge. We often encounter PDFs that contain structured data we would love to analyze in Excel. Our client had a 60-page PDF that he needed answers from the data to run his...

read more

Supporting your growing business

Here’s a situation we run into with our client. Someone builds a model in Excel and it works great. Time goes by and the business grows. That single workbook gets copied for the new customer/division/business unit. Quite a bit of manual work is needed to make it work...

read more

Will Excel go away?

I was recently asked whether Excel was going away. Now, I’m not a Microsoft mind reader but… here’s why I think Excel is here for a long while. Excel is too easy to use for it to go away. Most people can create a spreadsheet that reflects their business needs. That’s...

read more