Hi,

I have a PowerPoint Presentation that is linked to live graphs in excel. Each time I change the pivots in excel the graphs change on the powerpoint. There are 4 graphs on 1 slide. I need to copy the entire slide and paste it into a new powerpoint slide, but without any of the links to excel( i.e pictures only). This is then repeated numerous times depending on how many variations of the graphs are required based on a selection in excel.

I currently have a macro that copies the slide each time the pivot is updated into a new document.

Please an example of the code below:

Please Login or Register  to view this content.

The only problem is that this takes some time to run, and I do not require the links to be saved in the new powerpoint. I dont want them to update once the report is compiled.

Any help would be great,

Thanks

Alistair