Excel Charts linked to Power Point Presentation

Hi there

I am looking at the possiblity of using linked charts in my power point document to the charts in excel. I know this can be done but the problem I have is that,

I want to be able open the poeerpoint file and update the links, and then I want to be able to distribute to other people without the other people being given the option of updating the links(i.e. as if the file they are receiving has no links).

Is there a way this can be done? Appreciate any pointers.

I am using Office 07

Thanks

Could you not just simply break the links before you send it out?

Originally Posted by brokenbiscuits

Could you not just simply break the links before you send it out?

Thanks for the suggestions brokenbiscuits

I initially came across this http://www.ozgrid.com/forum/showthre...t=82328&page=1

which led me to the following macro which does the job here http://skp.mvps.org/ppt00047.htm