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