The error you see “Unable to open ...... Cannot download the information you requested" is a very usual error when hyperlinks do not work in the excel sheet. There are a few ways to fix this, I am sharing a few steps which might help in this case.
Open Excel Workbook ->Go to File->Options->Advanced Scroll down to find the General tab and click on Web Options
Web Options Window pops-up
On Web Options, pop-up, Click on Files and Uncheck the box for “Update Links on save”
Click OK button and your option is saved.
Cheers!