sql server reporting services: How do I remove hyperlinks from reports that are exported to Excel?

Help, I have the same problem. I added actions to all my text fields to
allow me to filter the report when a user click a cell. I had no idea this
would totally ruine the report when exporting to Excel (each cell is now a
live hyperlink to the live report - FROM EXCEL!!) Te sheet has grown from a
couple hundred K to 22 MB!!! How can I have these textboxes revert to just

Essentially, you'll write an expression for:

Navigation:
=IIF (Parameters!render_format.value <> "html", nothing, "[report name]")

Text Decoration (to underline if a hyperlink):
=IIF(Parameters!render_format..Value = "HTML4.0","Underline","None")

Color:
=IIF(Parameters!render_format..Value = "HTML4.0","Blue","Black")

Scott


[quoted text, click to view]