HyperLink help please

[malfromcessnock]

Hi board members. My first post.

I'm writing up a book listing all my videos etc. I'm busy doing the hyperlinks for each entry and I want to avoid all the clicking.

My videos are on N:\ and everytime I click to find the file/folder/url/image relating to the movie - all in N:\ the damn thing defaults to L:\

I thought and would like it to start looking at the last place I made a hyperlink. I have never made one from L:\

Is there a way to set a default starting place. I have hundreds of videos and each video has 4 links.

I've closed Excel and restarted it.

I've shut down and restarted the computer, but each time it begins the hyperlink process in L:\

Anyone got any ideas, it could save me hours and a busted mouse!

Cheers, Mal