Hi guys

Setting:
Every week I'm handing in a report to my superiors. The report consist of about 40 charts which I with 40 pivot tabels have created.

Problem:
My problem is that every week i have to inset these 40 charts into powerpoint because the powerpoint document wouldn't update the charts as i refresh my pivots.
The funnt this is when i insert a new chart into my powerpoint i changes the chart in excel it updates. But as soon as i close it down (and openingen it next week) the doesn't update my changes in excel!

Any suggestions?