Link and change source for multiple tabs from excel to powerpoint

[excel3]

Hi Friends,



I have to prepare a monthly presentation for my company. I have all financial data in multiple tabs in excel that have been linked to many powerpoint slides.

The problem is, I update the same excel sheet every month and save it with a different name. How can I change the source in powerpoint to select and update all the slides with all the corresponding tabs.

At present, I use Edit link (ALT+E+K) > Select each slide on the powerpoint> Change source to new excelfile. When I select all the sheets, the "change source" greys out. Hence I have to do it individually. Please help me be more efficient. This is very time consuming. I am sure there is a better option I am not aware about.

Using excel and powerpoint 2010

Thanks in advance

[JohnWilson]

As far as I know there's no way in the GUI to do this. If you do this that regularly I would write (or if you can't do it in house, get written) a small add to create a ribbon button to modify the links. I don't normally tout for business but my guess is we could do this cheaply and quickly for you if you are interested!

john ATSIGNHERE PPTAlchemy.co.uk