Oddly enough I just solved a similar problem today using tips from a google search.
The drive had worked, now it didn't. The same issue applied to some other external drives.
The solution, as touched on above was to us My Computer, then Manage, Storage, Disk Management, this listed all the drives including the external drive but it had no letter. A click (right I think) and then assigned a letter and it worked.