Having had some experience in automating ppt charts I realise that this doesn't look good.
, "If you need to automate charts in PowerPoint 2007, it'd be best if you change your name and move to another town where nobody knows that you do PowerPoint programming.
The chart objects you get in PowerPoint 2007 when you add a new chart expose no methods or properties to VBA. In short, you can't do anything with them in code."
With that beginning in mind
1) I have a series of PPT charts with data from the 'Edit Data' option in underling Excel spreadsheets
2) The data series are in turn linked to another spreadsheet (see red box in screenshot)
Is it possible to change the linked file source manually or programmatically?
Pls note that this issue does not relate
to edit OLE Links, the "Prepare" option under the Office Button does not show any links as these are native ppt charts.
Lastly pls do not reply to this question unless you can offer specific feedback to the problem. I have googled this at some length already :)