How can I change 255 character limit in 'hyperlink' function?

G

Guest

I am trying to use the 'hyperlink' function to compose URL addresses with the
'concatenate' function, but when the finished character string exceeds 255
characters in length I get an error. The problem seems to be with the
'link_location' field in the hyperlink command and not with the 'concatenate
function'.

Is there a way to increase the character limit for the 'link_location' field?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

character limit in hyperlink function 0
Is there a 255 character limit in pivot table cells? 1
Cell 255 character limit and formula 6
Can UDF return a customized hyperlink? 3
Need help with hyperlink character limit 3
How to create a hyperlink to open a file with part of the name 4
How to count number of characters in xl cell for publisher merge 11
beyond the 255 character limit 4

Top