Replacing a link to an external workbook

[iains]

Hi All<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am trying to replace the link by month to an external workbook.<o></o>
<o></o>
In Excel 2003 I could use Find and Replace and search on \[Oct09.xls], and find almost 2000 entries. I would then change this to \[Nov09.xls] and it would update all the entries.<o></o>
<o></o>
Since we have moved to Office 2007 Find can not find \[Oct10.xlsx], and so the Replace will not update the data.<o></o>
<o></o>
If it does find the link it take me to the folder where the workbook is, but I have to click on the workbook to get the link to open, and with almost 2000 entries this should be able to be done more quickly, as it was in 2003.<o></o>
<o></o>
There must be an easier way of doing this.<o></o>
<o></o>
Thanks in advance for any assistance.<o></o>

Iain

 

[xenou]

Try instead using Edit Links:
Pick the old workbook in the links dialog and hit the button to Change Source... Then browse out to the the new workbook and choose it.

You should only have to do this once and all links will be updated.

Note: Your find/replace method *should* work too, but you may want to be sure the "Old" and "New" workbook are open when you do this - Excel should recognize it without prompts that way and you should have fewer problems this way. Nevertheless, using the edit links dialog is probably best.

ξ

 

[iains]

Hi Xenou

Thanks for that, it worked a traet.

Iain