Had the same problem on my sons rover.
The speed sensor in the gearbox, is wired to the ECU and then in turn to the instrument cluster. Disconnect the battery and leave for about 10 minutes, this will force the ECU to do a cold restart. The speedo then worked. BEFORE doing this make sure you have the Radio code.
MikeP
August 2008