[ikthius]

as I said earlier, I can do this ok at home, but work is a problem.

the links are not changed when they are tested from word, but copying the hyperlink, does create the text to change from word to excel, e.g.
link in word value: Spinal training.doc
link in excel value: file///C:\training folder\SPinal training.doc

after clicking this works, then I can rename the link to just Spinal training.doc in excel and this also works.

but I have to do this all the time, which I should not have to do.

I work in a sports centre were we have training constantly, so all of the links have been used once from word to excel, for at least one coleague, so copying the link should work.

the formulae for the =hyperlink, does this put the link in the cell and them the cell can be copied over more easily?

I have just highlighted the link in word, copy hyperlink, then pasted into a cell.

ik