Powerpoint linked chart not updating
If the source range/chart is found in an open workbook with the same name as the source workbook, Macabacus looks no further.
However, if the source range/chart is not found in that workbook, Macabacus looks in all other open workbooks.
If any potentially newer versions of the source workbook are found, Macabacus prompts you to relink to them when updating links.
Version control uses Microsoft technology that limits the fully qualified file name to less than 260 characters, and the directory name to less than 248 characters.
Therefore, the name of a linked chart must (a) be different from the names of other charts on the same worksheet, and (b) not change after linking.
If multiple charts on a worksheet share a name, Macabacus may be unable to distinguish among them and for linking purposes may reference the wrong chart.
In addition, when you save your source workbook as a new version, all range names created by Macabacus for linking purposes carry over to the new version (as do all names), making it possible to relink previously linked objects in Power Point/Word to the new source workbook.
Now, what if we want to add a column to the right of the source range, so that our output in Power Point shows six columns instead of five?