Forum Discussion

LS1983's avatar
LS1983
Copper Contributor
Apr 14, 2020

How can I overcome the HYPERLINK Functions 255 character limit?

Hi!

 

I am trying to workout how to overcome the 255 character limit for the hyperlink function in excel. Currently I have formulated a HYPERLINK link which pre-populates information for a 3rd party form (JotForm) with values from my spreadsheet. 

 

It displays #VALUE! in the cell.

 

Does anybody have any suggestions or solutions for overcoming this issue?

 

Thanks!

excel
Macros and VBA

1 Reply

  • JamesMartin001's avatar
    JamesMartin001
    Copper Contributor
    Apr 13, 2026

    Windows 11 now, and this is still a problem. I have a hyperlink formula on a data entry sheet, I can link to the data point address postcode on an internal mapping system, but I am limited to automatically opening only two additional map layers due to the 255 character limit. 

    Metod 2 here doesn't work. I will try method 1 but I am not hopeful. Today I found a solution, basically create your greater than 255 characters url hyperlink in Word. Activate the url, with a space at the end or return. And copy and paste to a cell in Excel. 

    This is only a manual solution. If you look at the link properties in Excel, the pop up menu is different to the native one in Excel. I can't seem to hold the Word formats in the cells and paste in the under 255 characters formula. 

    Currently I have a helper hyperlink, above the table headers and the relevant column on the freeze pane, "Internal GIS with Useful layers. Copied from Word with about 900 characters. 

    Solution was on http://www.mrexcel.com with a thread called /how-do-i-do-a-hyperlink-that-exceeds-255-chatacters-539414/