Dynamic URLs in Excel 2007 are Not Retained when Exporting to PDF?

[Chris L]

I've been using Excel to create PDF invoices for my small home business (with
the official MS Export to PDF add-on), and include suitable payment links to
allow clients to quickly and conveniently settle their invoices. However,
I've noticed that dynamic URLs (i.e. those which make use of cell values with
the =HYPERLINK function) are not retained on PDF export. In the resulting
PDF, they're formatted as though a link (underlined, different colour etc.),
but they do nothing.

In the mean time I use static hyperlinks to take the client to a payment
gateway, where he/she will have to manually enter the invoice total. I'd
really love it if I could use dynamic hyperlinks to automatically use the
invoice total value in a direct payment URL to PayPal, for instance.

Please, if anyone can help with this bug, I'd hugely appreciated it.

Thanks,
Chris

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...bcfbc84&dg=microsoft.public.excel.crashesgpfs

 

[blis]

Hello, your solution is OO Calc. I have been bugging around same problem for 2 days, tried Adobe proffesional , mio of pdf printers (even thouse that are ment just for printing pdf from excel), and finaly found solution in Calc.
Just download OO from http://download.openoffice.org/other.html#tested-full, install it or use portable version. I used portable version and it worked.
Open Calc, go to File menu and choose Export as PDF. Notice all the setting for bookmarks and hyperlinks on tabs General and Links. Choose appropriete settings for you and click Export.
And thats it. Microsoft and Adobe don't have support for converting hyperlink function but OO does. Isn't this funny? Or is it sad?

Good luck to you.