I have develped a PP template with mutliple charts that were linked to a single Excel workbook. The idea was to update the template to different workbooks that represented different sales regions. The problem I ran into was in how the link is represented. It looks like this:



S:\Sales_Reporting\2010\QBR\NCC_Feed.xlsm!SalesCha rts![NCC_Feed.xlsm]SalesCharts Chart 1

When I update the links to, say, NCWC, the link now reads:
S:\Sales_Reporting\2010\QBR\NCWC_Feed.xlsm!SalesCh arts![NCC_Feed.xlsm]SalesCharts Chart 1

The [NCC_Feed.xlsm] portion of the link does not change. Is there a way to correct the link?

There are 20 or so charts, so I would really prefer a way to batch the processes. I am proficient in Excel VBA, so a VBA solution would be cool.

Thanks!

f