Excel hyperlink formula is not clickable when the workbook is converted to pdf

[bhaskarsharma03]

Hi,

I have created a "Table of Contents" sheet in my report which has hyperlinks to other sheets. I have used hyperlink formula to navigate to different sheets. This works fine in excel. However, when the excel is printed in pdf, the hyperlinks are non-clickable. Can anyone please help resolve this!

I cannot use Insert -> Link option, as while creating the excel report some of the sheets are not yet created, and they get generated during runtime from another application. If I try to create hyperlink by inserting link (for future sheets), it gives invalid reference error and doesn't allow me to enter the reference for the future sheets.

Appreciate your help.

Regards,
Bhaskar

 

[bobsan42]

Do NOT PRINT to pdf.
Use SaveAs PDF.

 

[bhaskarsharma03]

I wish I could. The entire process is run by an external application (Qlik Tabular Reporting). Only thing in my hand is to create the template. I create the template in excel, and upload it in the tool, the tool populates the report and prints it in pdf.

Regards,
Bhaskar