Is there a VBA in Excel that opens a Powerpoint file (master file that links
into Excel files), does the links automatically, break the links (to retain
the values and charts) and save the ppt file as a Pastevalue version ppt?

Cheers
Eddy