Workaround for HYPERLINK argument length limit

[aboorkuma]

Dear Member

The arguments for a HYPERLINK() worksheet function seem to be limited to 256
characters. Is there a workaround for this?

I need to embed functions like this
=HYPERLINK("mailto:[email protected]?subject=My Subject&body="&A1)
in a worksheet, and I need it to accept very long body arguments. If the
argument in this case gets much longer than 200 characters, the function
becomes a #VALUE.

Regards

[DonkeyOte]

I don't believe so, no.

You would most likely need to revert to VBA I'm afraid (ie Hyperlinks.Add etc...)

[olcottr]

I've recently run into a similar problem. Maybe what I've learned can help you. I was copying several hyperlinks from Sharepoint Datasheet view to an Excel 2007 Spreadsheet. First of all, Excel doesn't like # and & in the hyperlink address (there may be others I have not encountered). Once I got past that, the Excel hyperlinks would often open up the folder above the folder I wanted to link to. It turns out the hyperlinks were too long. I just lived with it until one day I had the epiphany to try Paste Special. It gave me the option to paste the hyperlink as HTML instead of XML. It worked! Apparently XML adds more metadata than I needed and thus made the hyperlinks too long.