[ikthius]

hey everyone,

this will seem a bit strange, but bear with me.

I have, in work, a lot of documents e.g. 1.doc, 2.doc, 3.doc.
I also have index.doc which has all of the above docs as links to their respective documents. I hover the link hold Ctrl and click left mouse button and this takes me to the document I am looking for.

All links work in the index.doc file.

in Excel, which is for retaining these file for training purposes, I want to link the links from the index.doc and copy this link to the Excel worksheet.

so I copy the hyperlink (with right clicking and choosing that option) from the word document, and paste in Excel. everything seems fine.

I can also copy these cells which have the link in them and copy them to another worksheet & book with no probs.

but recently in work I am not offered the copy hyperlink when in word, so because I have already used the links before (which work), I thought I could just copy the cells with the hyperlinks, but all it does is copy the contents, not the actual link (earlier this week it worked fine), it looks like a link but it goes nowhere, so I get an error.

is there anyway I can fix this?

the only way I can see is to edit the link in excel to where the link is going to, but this is too time consuming.

I have tested at home but I can do everything correct at home, but I am offered the copy hyperlink.

the example is small, I have over 100 documents for training purposes, which are all linked in the index, then I copy from the index to excel on to individual work sheets for normal personel, and another workbook, for senior personel.

ik