Formulas move when cutting and pasting workbooks

[jwillis07]

Hi all,

I've set up a spreadsheet structure at work which is three workbooks linked together.

I created this initially within My documents saved locally to my machine. Now though, I need to move the folder containing these workbooks onto the server to be accessed by others. My problem is that when cutting and pasting the folder, the formulas within the three spreadsheets still refer to their original location within My Documents rather than following the folder to their new location.

Does anyone know a way around this.

Many thanks,

Jason

[Olly]

Data > Edit Links > (Select Workbook) > Change Source

[Vikas_Gautam]

Obviously it will not..
as your worksheet and you formula have no control over the external computer environment....



Don't forget to click *

[FDibbins]

Open all of the files, and then save then all to te new location. Save the data WB's 1st, then save the Master WB/s. They should then all be saved with the new links. Just to be on the safe side (to make sure they all saved with the correct linking) save them all again

[jwillis07]

Data > Edit Links > (Select Workbook) > Change Source

Cool thanks, managed to change the sources.