move excel folders

Hi again,

I have 6 excel linked each other by actions and formula and are all together in a pen. The paths of the sheets are accordingly to the path of the pen.

I want to move the documents to another folder chosen by the user but the paths refreshed automaticaly without any errors.

For example, the folder is named "Excel guys are great" and I want to move that folder from C:\ to G:\ but i want that to work just fine without the typical errors of path not found or hyperlinks broken, etc.

Cheers

Sorry, I can't understand what you are asking

for example,

you have two excel documents (1 2) in a folder A. The document 1 has a formula that uses a value in document 2 (the path should be something like c:\A\[1])

If i change the two documents from the folder A to a folder B, then an error will occur because the path of the cell will be maintained and not change automatically whatever the folder the documents are.

sorry for my bad english