Geoff, Windows does recognise an unformatted drive but might not an unpartitioned drive. Partitioning is the step before formatting.

I am surprised that if the problem is as I've read it that Knoppix does not recognise it. I've not used it but would have expected it to find a disk on the system regardless of partition/format state.