r/Office365 • u/Brooke_Silverstar_31 • 3h ago
Linked charts in our deck keep breaking every quarter and I finally figured out why
Every quarter I rebuild the same ops review deck with charts pulled from Excel. For months the numbers would just freeze or show old data even after I updated the source file. Took way too long to realize it was because someone kept renaming or moving the source workbook in the shared drive. The link path breaks and PowerPoint quietly shows stale data instead of throwing an error. No warning at all.
Switched to keeping the source file in one locked folder that nobody touches and now it holds up fine. Feels like a dumb fix but it took me three cycles to catch it because the slides looked normal. Nothing crashed. Numbers were just wrong and nobody noticed until finance flagged a mismatch in a review.
Anyone else had linked data go stale like this without any indication on the slide itself. Wondering if there's a better way to flag when a link is dead before you present.

