How to export Hyperlinks from Crystal V11???

[SQLRory]

Hi people,

I have written a report using Crystal v11 and have included a Hyperlink to a file location of V:\ClientTracking\MAYTAS\Reports\ExceptionReports\MLive Exception Report.xls, however when exporting data only and also exporting the object formatting the hyperlink doesn't work once in Excel.

The hyperlink will only work if I:
right click
Edit Hyperlink
make no changes
click ok

then the hyperlink then works even though I made no changes?

It's as if a trigger isn't taking place as the report is exported.

Can anyone please shed any light on this?

Thanks

Rory