98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel course london - Sources for links
advanced excel course london - Sources for links
Resolved · Low Priority · Version Standard
Mon 21 May 2007, 16:31Delegate Rachel said...
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.
Thu 24 May 2007, 14:42Trainer Richard said...
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
Tue 29 May 2007, 09:22Delegate Rachel said...
RE: Sources for links
we are using it to link an excel spreadsheet to a word document, which has about 5,000 links
Thu 31 May 2007, 09:26Trainer Richard said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Converting an American date format to European using FormulaExcel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following. |
