Web links not working in excel cell

Hi,

Hyperlinks to web pages from excel cells are not working.

I copy URL from web browser and paste it in address part of hyperlink dialogue box.

Only 255 characters are pasted, and URL contains more, so when I click to hyperlink it shows error in IE.

I've tried hyperlink function and it also has constraint of 255 characters.

I know it can work, because I've seen hyperlinks with more than 300 characters that work but  I don't know how.

I'm using excel 2016.

Thanks in advance

Hi,

To address your concern, kindly refer to this link regarding Hyperlinks in worksheets in Excel 2016 for Windows.

Let us know how it goes.

Regards.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi,

I've tried it and no suggestions are working for me, even when I use the option browse the web it's not working because it still cuts off everything over 255 characters.

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Are you pasting the URL in the column width? If yes, then kindly refer this link regarding Excel Specifications and limits, check the Worksheet and workbook specifications and limits section.

Let us know if you have any other questions.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi,

Ccolumn width limitation is 255 characters, but I've wrapped text in cell so now it's OK and it can contain more than 255, but the problem is that when I copy URL from web browser and paste it in address bar of edit hyperlink dialogue box only 255 characters are pasted, and URL contains more, so when I click to hyperlink it shows error in IE.

The picture below shows the problem after"...RootFolde" should be more than 100 characters. Clipboard paste only 255 out of 380.


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

This is because wrapping text in a cell still won't allow you to exceed the 255 character limit. Wrapping text in a cell  just fits all the text for it to be visible, but it doesn't mean that it will change the 255 character limit.

Keep us updated.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi,

OK, so wrapping text in a cell  just fits all the text for it to be visible.

What about initial problem i.e. when I copy URL from web browser and paste it in address bar of edit hyperlink dialogue box only 255 characters are pasted.

I know it can work, because I've seen hyperlinks with more than 300 characters(in address bar are that long) that work but  I don't know how.

Thanks in advance

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated July 30, 2020 Views 13,794 Applies to: