• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Limited Characters in HYPERLINK

K

kissha

New Member
Hello All,

this is my firrst time. I need help on the limited characters od url in hyperlink formula. I have a report that I need to link to a website. However, excel 2007 does not allow me to input more than 256 characters of URL in hyperlink formula. As of now, the number of charcters of my URL is 302. i need advise on how can i link 1 cell to a website. And no macro please. thanks a lot!!!
 
Hi ,


I do not know if a solution without a macro is possible. In case a macro is the only way , then here is a link to the solution :


http://www.excelforum.com/excel-programming/783698-writing-variable-source-hyperlink-macro-255-char.html


Narayan
 
Hi ,


How are you going to input the URL ? By typing in the 302 characters ? Or by copying the URL from some other document / file ?


For example , one of the posts in this forum has the following URL , which has more than 255 characters ; when I copy the URL into Excel , there is no problem. However , just pressing F2 to edit it and pressing the ENTER key no longer makes it work.


https://docs.google.com/viewer?a=v&pid=gmail&attid=0.2&thid=1338bb99985631ba&mt=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet&url=https://mail.google.com/mail/?ui%3D2%26ik%3D33b7a5fb92%26view%3Datt%26th%3D1338bb99985631ba%26attid%3D0.2%26disp%3Dsafe%26realattid%3Df_gut98uvg1%26zw&sig=AHIEtbRSi0CN9b1lFnlFRjBSR4Dbsd8ZKg


Narayan
 
You must log in or register to reply here.
Back
Top