Hi,
I have created a report in Tabular using Page feature (from Levels and pages option). I have created a "Table of contents" in the first sheet where I need to give hyperlink for each of the pages/sheets.
Since I am using Page feature, the final report sheets are yet to be created (will be created during report run time). While creating the hyperlink to the individual sheets, I am using Hyperlink function of excel to create the hyperlink
eg:
=HYPERLINK("#Main!A1","Main Sheet")
This works great if I preview the report in Excel. However, doesn't work in PDF.
I cannot use Insert -> Link option in excel to enter the hyperlink as the sheets are not created yet in the template.
Any idea how can I get the hyperlink working in pdf!
Regards,
Bhaskar
