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