advanced excel course london - sources links

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

resolvedResolved · Low Priority · Version Standard

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


 

Excel tip:

Converting an American date format to European using Formula

Excel 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.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips


Server loaded in 0.08 secs.