Hi guys. I needs some advice on a feature to add in a spreadsheet. I am trying to put in a formula controlled hyperlink in excel that will be saveas or printed to a PDF file. I have zero problems with the link formula, but cannot seem to get a PDF file with the links active. My formula utilizes a table where row 1 are the familiar names and row 2 are the links. The formula below works great in excel:
=IF(Students!AV3="INTRO TO MAYA",HYPERLINK(VLOOKUP('Days Off'!G4,Tbl_Links,2,0),'Days Off'!G4),IF(Students!AV3="AUTOCAD",HYPERLINK(VLOOKUP('Days Off'!G5,Tbl_Links,2,0),'Days Off'!G5)))
Now i can perform the normal step inserting a hyperlink manually and have it active when doing a saveas PDF, but having the links generated through the formula above, does not return an active link in the generated PDF. Any thoughts? Thanks in advance!
=IF(Students!AV3="INTRO TO MAYA",HYPERLINK(VLOOKUP('Days Off'!G4,Tbl_Links,2,0),'Days Off'!G4),IF(Students!AV3="AUTOCAD",HYPERLINK(VLOOKUP('Days Off'!G5,Tbl_Links,2,0),'Days Off'!G5)))
Now i can perform the normal step inserting a hyperlink manually and have it active when doing a saveas PDF, but having the links generated through the formula above, does not return an active link in the generated PDF. Any thoughts? Thanks in advance!