I have an annoying problem that keeps coming up. I have sheets and sheets of
charts (we produce about 400 of them every quarter, distributed over 2
files). I have the charts linked to certain other files, which get updated
regularly. For some reason every time I am using the chart file a new
quarter, a few of the charts link to old files that are no longer the active
ones. I change the links, save new copies of all (and I do it in the order
that is necessary for the chart files to remember the new names, so I know
that's not the problem), and then am done with it. At this point, it is
happening, and the way I find the links is just to go through each chart and
click on the items until I see the name in the formula bar that is an old
file name. The I know I just need to update that link to the new file. Is
there any code I can use that would effectively:

1) search each sheet of the workbook
2) on any sheet, search the source links for every input of each chart on
the worksheet
3) if it's got a particular string in the links, tell me (pause on it, write
down the chart title, anything).

This way I could just run the macro to know where I need to go, as opposed
to clicking through the visible data items of all the charts each time.

Thx.
--
Boris