philfer
11-03-2008, 07:37 AM
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
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