Keep the figures you report in a consistent workbook structure. For this sales example, the sheet is named Summary: B1 contains the reporting date, B2 the revenue, B3 the growth rate, and B4 the top region.

Make a copy of your existing PowerPoint deck. In that copy, replace each changing figure with a token that points to the corresponding cell. You only do this setup once; keep this marked-up copy as your template.

The part before | identifies the cell. The part after it formats the result. You can also reference an Excel named range, such as {{TotalRevenue}}. Tokens split across text formatting runs still resolve; the replacement inherits the first character's formatting.

For these objects, use a shape name instead of typing a token. Open PowerPoint → Home → Select → Selection Pane, select the object, and rename it with the directive below.

table:Regions!A1:D5

Use an existing PowerPoint table. The range fills the table and resizes its rows and columns while inheriting the template's cell styling.

chart:Regions!A1:D5

Use an existing chart. The first column supplies categories and the header row supplies series names. Add ;orient=rows to switch orientation. The displayed chart cache updates; the embedded worksheet behind PowerPoint's “Edit Data” keeps its original values.

picture:Regions!A1:D5

Use an existing picture as the placeholder. The browser renders the range as a neutral table image and replaces the picture in the same position, size, and layer order. The Excel add-in edition provides a pixel-perfect Excel picture.

1. Save your workbook in Excel after changing formulas. The browser reads saved, cached results; it does not recalculate formulas.
2. Add the workbook to the source area. Add one or more marked-up .pptx files to the template area.
3. Optionally add an approved log CSV from a previous run to compare against that baseline.
4. Refresh. Tokens, tables, charts, and pictures resolve against their named sheets or ranges. Your original template remains unchanged.

For batch output names, your workbook can include a Decks sheet with Template, Output, and Skip columns. Tokens on a slide layout or master resolve once and appear on slides that inherit them.

The slide preview shows how the figures land in the template's shape geometry. Each action is logged with its source reference so you can trace what changed.

Read-back verification

The generated PowerPoint file is reopened from its own bytes. Text values, table dimensions, chart series and point counts, picture replacements, and unresolved references are checked against the log.

Baseline comparison

With an approved log, moved values are tagged CHANGED. A reference that stopped resolving or a renamed shape can produce MISSING or MISMATCH findings. Download findings as deck-updater-qc.csv.

Unresolved references

They stay visible in red in the preview and remain unresolved in the deck. An error does not abort the entire run; a deck can still be saved with issues. Review the findings before sending it.

Download the updated PowerPoint deck after checking the results. Keep the original template for the next reporting period; swap in the next workbook and repeat.

PDF export is a read-only circulation copy. It uses the preview, which simplifies template fonts, theme colors, and effects. Updated charts appear as signed bar charts regardless of their original chart type; charts without directives appear as labeled outlines. For exact styling, open the finished deck in PowerPoint.

Your GitHub example pairs Lynch_Buffett_Stock_Evaluation.xlsx with Investment_View_Template.pptx. Forty-two values feed six slides:

1. Recommendation, price, fair value, upside, and buy-below price.
2. A decision summary table and a valuation-bridge chart.
3. A chart of six score modules.
4. Forecast rows and a five-year revenue chart.
5. Eleven data-quality checks with details.
6. Assumptions against history and the metrics behind the score.

For example, {{03_Output_Decision!B12}} reads the recommendation, and table:03_Output_Decision!A5:B15;header=0 fills the decision table. The model's blocking flags force REVIEW and withhold unsupported fair-value outputs. These checks come from the workbook; Deck Updater transfers their results.

Open the workbook, template, inputs, and full walkthrough ↗