Stale Charts, Block SmartArt, and Playback Failures in a Launch Deck
A pharmaceutical launch deck contains six charts linked to one Excel workbook, a SmartArt patient-journey diagram with five stages, a rotating 3D molecule of the compound, and a 90-second MP4 of the manufacturing line. The workbook was rolled to Q4, but the deck still shows Q3; a colleague "updated" one chart by typing into the sheet that opened from Edit Data, and now her numbers differ from the master workbook. The SmartArt currently flies in as one block, but the team wants each stage on click. On the conference room PC the 3D model appears as a flat still, and the video opens in Windows Media Player instead of playing inside the slide. The deck will be shown on a mix of Microsoft 365 Apps, Office 2019, and PowerPoint for the web.
1. Diagnose why the charts show Q3 and why the colleague's numbers differ. What data architecture would you recommend for a distributed deck?
Read the worked answer
A linked chart keeps its data in the external workbook and a cached copy inside the presentation. Q3 numbers mean the cache was never refreshed after the workbook rolled: use Chart Design > Refresh Data, and check File > Info > Edit Links to Files to confirm the source path is intact. A moved or renamed workbook leaves the link broken and the stale cache on screen.
The colleague typed into the sheet opened by Edit Data. If the chart was linked, that edit either went into the cached workbook and will be overwritten on refresh, or it broke the link and became the de facto source. Either way, two sources of truth now exist.
For distribution, break the link so the deck is self-contained and shows exactly the approved Q4 numbers; keep the master workbook as the record. For a deck that is updated monthly, keep one link, refresh before every release, and never type into the chart sheet. Never patch numbers by editing data labels manually, because the labels will no longer match the chart.
2. How do you make the five SmartArt stages appear one at a time, and what are the trade-offs of converting to shapes?
Read the worked answer
Select the SmartArt, add an animation, then open Effect Options and choose One by One; for hierarchical layouts, By Branch is often better. In the Animation Pane, the SmartArt expands into its individual shapes, so you can set the first to start On Click and the rest to With Previous or After Previous depending on whether the presenter controls the pace.
If the layout does not expose the grouping you need, SmartArt Design > Convert to Shapes gives you ordinary shapes you can animate individually. The trade-off is real: you lose the SmartArt layout engine, later text edits will not reflow as SmartArt, and reading order and alt text may need repair. Keep the original SmartArt on a hidden backup slide or in a separate working file.
For a five-stage journey, try One by One first. Only convert if the animation cannot be achieved, and afterwards check the Selection Pane order so the stages are announced in sequence.
3. The 3D model is a flat still on the room PC and the video opens externally. What do you change for a mixed-version audience?
Read the worked answer
The 3D model requires a supported PowerPoint build and format. Office 2019 and Microsoft 365 support 3D models; older versions and some web views show the fallback still. For a mixed audience, do not rely on 3D as the only carrier of meaning: put a high-quality still or a short rendered video on the slide used in the room, and keep the interactive 3D model on a slide reserved for known Microsoft 365 machines. Test on the actual room PC, not your own.
The video opens externally because the file uses a container or codec the room PC cannot play inside PowerPoint, typically a .mov with a nonstandard codec. Convert to MP4 with H.264 video and AAC audio, insert with Insert > Video > This Device so it is embedded, and do not use Link to File if the deck travels. Set Start: Automatically if it should play on slide entry, and run Compress Media for compatibility. Test with the projector connected, because audio routing and hardware acceleration can change behavior.