Updating Excel charts in PowerPoint

[tobermory]

I have a PowerPoint with approximately 10 slides of charts and objects linked to the same one spreadsheet. The data in the spreadsheet updates every month, I need the charts and objects within the PowerPoint to update to reflect the new data. I therefore copied the charts and objects over adequately and 'linked' the file in 'Edit Links to Files' in PowerPoint and ticked 'Automatic Update'.

When I subsequently open the PowerPoint, I get the following error messages.

Some of the charts and images update, some don't. What I find odd is, when I manually 'Refresh Data' and 'Update Link', it works completely fine.

Would there be a way to manually record a macro within PowerPoint that records me 'manually' updating the charts and images, so I don't have to manually do it every month?

 

[Domenic]

As per the error message, did you make sure that the linked file was saved before copying and pasting the chart? And did you make sure to paste and link the data, instead of embedding the workbook?

 

[tobermory]

Hello, thanks for reaching out!

Sincerest apologies for taking so long to reply. Yes. I save the spreadsheet before copying and pasting, I also paste Using 'Source Formatting & Link Data'.

When I open the PowerPoint and 'Update Links', it seems to work on the first couple of occasions. It's only when the data in the spreadsheet updates I seem to get error messages implying linked data isn't available. The actual name file name of the spreadsheet hasn't changed, just the data within it.