PowerPoint table and charts linked to excel updates by VBA

Dear friends,
I have one excel file (Excel Template) and one Presentation file (Presentation Template Macro). The idea is to…

---Open Excel file -> update the data -> save -> close it.
---Then open powerpoint -> run VBA code -> update the presentation (which is linked to the excel)

Problem: Code updates the first slide properly from sheet1 but the second slide is not getting updated. The code I have used is not mine. Can anyone please let me know why slide 2 is not getting updated?

For your reference i have uploaded the two files
(Sorry i used third party to upload the file, as in my browser i was not able to upload the file directly in the Post)
http://s000.tinyupload.com/?file_id=...90137459088195

Here is the code used to update the presentation:

Please Login or Register  to view this content.

THIS POST IS MIRRORED @ http://forum.chandoo.org/threads/pow...-by-vba.29594/

Good morning friends,

Any help on the above is welcomed...

wow i posted the same thing about a month ago and got no reply . . staying tuned to this to see how it best can be accomplished