Rachel has attended:
Excel Intermediate course
Sources for links
I am linking a word document to an excel spreadsheet, but wish to change the names of both the excel spreadsheet and word document without loosing the links. I have already changed the name of the word document with no problem but do not know how to change the links unless it is to do each one individually.
RE: Sources for links
Hi Rachel. Generally, if you have the files open that you are linking together, and then you Save As, the other file will recognise that the fiole name is being changed.
Are you using this for Mail merge, or just a simple hyperlink?
Regards
richard
RE: Sources for links
we are using it to link an excel spreadsheet to a word document, which has about 5,000 links
RE: Sources for links
Hi Rachel,
Could you clarify which document has the 5000 hyperlinks, and where they link to. I am not entirely sure I understand what you want to do.
if you send an example of the file to richard @ microsofttraining dot net I can take a look at it in more detail.
It could be a simple step, or perhaps something a bit more complex.
Thanks
Richard
