I had this problem on my Dell 7447. Never used the CD / DVD drive but recently ripped 50 audio CDs on it. A week later CDs just make clicking sound and Windows did not recognise them. Tried all the Dell troubleshooting steps. SupportAssist passed the CD test, Device Manager reinstalled the driver 10.0.16299.15, defaulted autoplay settings, etc. Finally last attempt was doing a System Restore. It worked!! Windows Update had run a few days ago. I wouldn't have even thought of this. The restore said it could not complete possibly because of windows antivirus, then i rolled back to before the restore, then the CD worked again :)