referencing moved workbooks

[mrjayps]

I have built two separate workbooks in excel. One being a shared 'database', the other being a calculation tool. I am needing to move the shared database to a different location as well as needing to move the calculation tool to a few peoples desktops. When I move the workbooks to the desired locations, the formulas are still referencing the old locations..

so it may say = \\SHAREDDOCS\PRICE\BACK UP\[Database.xlsm]WORKINGS'!E3

where I need it just say =[Database.xlsm]WORKINGS'!E3

problem is there are many cells referencing back and forth between these two workbooks. is there anyway I can update them all at once rather than going into each one individually.

any help would be much appreciated.

thanks

 

[Expiry]

Go to Edit, Links. Select the file that you're currently linked to. Choose Change Source and repoint to the one in the new location.