kinell walkon40 - What have you done ?

As you said, it is sending you all over the place, but it seems to me that you are over-complicating it. Why mark 22 waypoints, when you only really need 2, ie the start point and end point. Let Mapsource do the rest, and work out the route for you. Unless you have to or want to use a certain road, I personally would not click on them - let the computer do the work. Eg 2 accurately marked waypoints 1 called "Home" the other say "Shipton Hotel", highlight both, right click, press "Select Route Using Selected Waypoints" and voila - job done.
I have just had a stab at creating a route from the file you attached, and it worked fine, by just using the first and last given waypoints - giving a route length of 47.5 miles. By the way I assume you didn't attach a file with all the waypoints in, as your last waypoint is nowhere near Derbyshire. Try zooming in as much as possible when creating a waypoint - to make sure that it's accurate, eg your last waypoint in your attached file was approx 60' north of the Eastbound carriageway of the M42 & I doubt you really intended to stop there.
A friendly word of warning when routing via dual carriageways or motorways, as Metro mentioned - make sure you zoom in so that you can see both lanes -
in effect they are 2 separate one way roads then mark the one you want. If you don't zoom in enough and just click on say the M42, you could easily click on the wrong carriageway, which would give you daft routes. Just don't ask how I know.
