So in my work, I create an excel spreadsheet. The spreadsheet has cells with hyperlinks in them. When clicked on, the user is taken to another cell within the spreadsheet. Sort of like an anchor.
So I was reading on the web that there are no free PDF Printers that can print from Excel to PDF and maintain hyperlink functionality. So I got Adobe Acrobat Pro 7, and when I try to create a PDF from my Excel workbook, the links still aren't activated.
At first, I tried creating a PDF from a workbook with page breaks I had set out. But Acrobat said it couldn't maintain hyperlinks if page breaks were present in the workbook, so I removed the page breaks and Acrobat is still not creating a PDF with active links.
How can I overcome this? Is there an option I should enable in Acrobat?
Thanks for any help!