Hyperlink not working when Exported to Excel

[Gregory]

I'm using the hyperlink on a Textbox (not a HTMLTextbox but rather a plain Textbox).   I did this via the Action property and selecting Navigate to URL with Link Selected set to NewWindow.   The target URL is set to the following expression:

= Parameters.URLPrefix.Value + CStr(Fields.SERVICEREQUESTIDNUM)

It works great in the Report Viewer and when I export it as a PDF, but not in Excel.   How do I fix this?   Is this an Excel setting that is preventing me from hyperlinking.  Thanks.

[Chavdar]

Hello Gregory,

Currently Telerik Reporting supports two Excel formats: Microsoft Excel 97-2003 (BIFF, v.8) and Microsoft Excel 2007 and above (OpenXML 2.0). One of the differences between them is the hyperlink support. Please, make sure you are exporting to Excel 2007 in order to have working hyperlinks. More information about the Excel rendering extensions you can find in the Design Considerations for Excel Rendering help article.

Kind regards,
Chavdar
the Telerik team

[Gregory]

The only export options I have are:

Acrobat
CSV
Excel 97-2003
Rich Text Format
TIFF
Web Archive
XPS

I running Telerik reporting Q1.

[Chavdar]

Hi Gregory,

It seems like the new Open XML rendering extensions (Word, PowerPoint, Excel 2007) are missing from the export options. To enable them you have to reference

• Telerik.Reporting.OpenXmlRendering.dll and
  
• DocumentFormat.OpenXml.dll from the Open XML SDK 2.0 for Microsoft Office (v.2.0.5022.0 or above).

To avoid the installation of the Open XML SDK you can reference the required assembly from C:\Program Files (x86)\Telerik\Reporting Q1 2011\Examples\bin folder. Note that they require .NET Framework 3.5 SP1 to be installed first.

Hope this helps.

Regards,
Chavdar
the Telerik team

[Gregory]

Once I added both the Telerik.Reporting.OpenXmlRendering.dll and DocumentFormat.OpenXml.dll to the references, the web viewer (I using the webform version) started showing the extra export options.   Interesting that the OpenXML options just say Word Document, Excel Worksheet, and Powerpoint Presentation and do not say "2007" anywhere.   That works for me (I probably a good thing not to go that specific).    The hyperlinks now work!     Thanks for you help!

[Chavdar]

Hello Gregory,

You are correct. The official name of the rendering extension is Excel Worksheet. Open XML file formats were introduced with Office 2007 so you may refer to it also as Excel 2007.

Best wishes,
Chavdar
the Telerik team

[Sam]

This is an old post but I'm hoping someone can help me. I am trying to export my report to an Excel file and I've installed the OpenXML 2.0 to get the extra options as noted above. However my links still won't export. I've tried the Excel Worksheet as well as the Excel 97-2003 options and neither works. It exports fine to PDF and Word but just not Excel. I am setting the hyperlink via the value field for an HTML text box. I've also tried setting the Navigate To Url property and that doesn't work either. Any help would be appreciated. 

 

[Stef]

Hello Sam,

In XLS files interactivity is not supported. In XLSX files you can have clickable links opening content in the machine's default browser. Note that the HtmlTextBox content is rendered without any formatting in Excel - Design Considerations for Excel Rendering.
Using a NavigateToUrlAction on a TextBox item works as expected, test with Telerik Reporting Q1 2016 SP1.

To generate an XLSX file, in the start project you need to have references to Telerik.Reporting.OpenXmlRendering.dll and Open XML SDK 2.0 for Microsoft Office(DocumentFormat.OpenXml.dll v.2.0.5022.0 or above with proper binding redirect).


Let us know if you have any further questions.

Regards,
Stef
Telerik

[Sam]

Thanks Stef for the reply. I'm using TextBox instead. 

[Keira]

To fix the issue try to recreate the Hyperlinks again.
Solution:
Try recreating the Hyperlinks again to target renamed worksheet.
Make use of the correct address presented in current worksheet.

Or else try this

Open Excel Workbook > File > Options >Advanced
Locate the General tab > click Web Options
Now Web options Windows appears > click Files > Uncheck box for “Update Links on save”
And click OK button to save the option.

source: http://www.repairmsexcel.com/blog/troubleshoot-excel-hyperlinks-not-working