moving spreadsheets to another network drive messing up formulas

[oneblondebrow]

Hi all,

I have a few spreadsheet which has formulas that enable each spreadsheet to share data with eachother, i need to.move them all to another location on my network drive but obviosly this will then mean all the formulas will be looking in the wrong place for the data on the spreadsheet.

Is.there anyway around this that does not involve me adjusting every single formula with the new locations?

many thanks

[newdoverman]

Copy the whole part of the file "tree" where the Excel files are located to the new location. The other alternative is to place all the Excel files that are linked together into the same folder, fix the references and then copy that folder to the new location.