Solved: updating many functions in a sheet together

[philfer]

Hello,

I have a worksheet that has several functions in it which refer to another workbook.

If that workbook is moved the formulae no longer work

Is there any way I can update all the formulae at one time to refer to the new workbook or do I have to update them individually

Thanks
Phil

[Bob Phillips]

Edir/Replace - Ctrl-H