Hello there,
I have Seen that File and link, after clicking on the link it;s asking for a login details but you want hyperlinks change to the PDF, is the PDF links are public if yes then it's okay. if no.
than we have to Download all the PDF and upload all of them to slidershare or any PDF sharing Public site so that PDF Slideshare link into Excel.
I can do this Project.