automatically changing external links to "Roaming" version

[tdg]

Hi,

I'm having major problems when Excel changes links in one of my workbooks to a "Roaming" version of the link. I can fix the problem when it appears in a formula in a cell, but how can I quickly change all the links in a bunch of charts? I have many charts that each refer to 15 different spdshts. So changing all the series manually would be a terrible pain. Excel doesn't see these when you do Find/Replace.

Also, what do I need to do in the future to avoid Excel making this change?

Thanks!
Tim

 

[GlennUK]

Doing Edit/Links/Change Source changes all references at once.