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