Dynamic Hyperlink to a specific workshet on a web published workbook.
 

Hi everyone.

I am trying to link to a series of cells in a workbook that is hosted
on a Webserver (Plone Enfold Desktop). I can get it to work this way:

=IF(ISBLANK('http://192.168.9.161:8080/QAPortal/Ultrasound/Ultrasound
%20QC%20Reports/[iU22%20L9-3%2002V9CM.xls]Summary'!C1),"",'http://
192.168.9.161:8080/QAPortal/Ultrasound/Ultrasound%20QC%20Reports/
[iU22%20L9-3%2002V9CM.xls]Summary'!C1)

But since I have over 200 to link to (each with different names) i was
hoping to put the iU22%20L9-3%2002V9CM portion (this changes for each
filename) into a cell reference that is a cell reference(i.e.
iU22%20L9-3%2002V9CM is also in Cell F224 in the same worksheet) using
the &, but I cannot for the life of me figure out how to make it point
to the spreadsheet using the HYPERLINK funtion.

I tried this but could not get it to work:
=IF(ISBLANK(HYPERLINK("http://192.168.9.161:8080/QAPortal/Ultrasound/
Ultrasound%20QC%20Reports/["&F224&".xls]Summary'!B2)")),"",'http://
192.168.9.161:8080/QAPortal/Ultrasound/Ultrasound%20QC%20Reports/
["&F224&".xls]Summary'!B2)

But all I get is a #REF.

Any help would be greatly appreciated, I could do it the liong way but
would like to make it easier to insert links to newly acquired files
just by dragging!

Tony