Update PowerPoint from Excel using a Database and Excel

05.31.2022

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

Franklin Knows Best

For the want of an audited formula the report was inaccurate,For the want of an accurate report money was lost,For the want of money the company was lost,For the want of a company the jobs were lost,For the want of jobs the economy was lost,And all for the want of an...

read more

Merging Inventory Lists

Here’s how we resolved a recent customer’s project. Customer’s Current Situation - The client receives updated inventory lists from a variety of customers. They need to be reviewed and validated before uploading into the client ‘system. They had to first move the...

read more