Forum Discussion
PetriN2040
Sep 17, 2020Copper Contributor
Excel with hyperlink
I use in excel (=HYPERLINKKI($H$1&A51&$B$1&D51&$C$1)) after some times of using it automatically stops working. I get an error message. If I change parameter it works again. Probably somebody thi...
PReagan
Sep 17, 2020Bronze Contributor
Hello PetriN2040,
- What is the error message that you are receiving?
- When you receive an error, is the hyperlink receiving an error a valid web address?
- Excel limits a cell's width to 255 characters; is the hyperlink receiving an error within the 255 character limit?
PetriN2040
Sep 17, 2020Copper Contributor
Hello PReagan,
The message is something like "could not open the link". Link is an ordinary copy of a google search. I could execute it at the same time in a browser.
The problem must be that I search data too fast because usually when I create a similar excel there will popup a captcha check to check if I am a robot or not.
Then after awhile the error appears. It will start working ok after a short break.
This a microsoft bug I believe.
The message is something like "could not open the link". Link is an ordinary copy of a google search. I could execute it at the same time in a browser.
The problem must be that I search data too fast because usually when I create a similar excel there will popup a captcha check to check if I am a robot or not.
Then after awhile the error appears. It will start working ok after a short break.
This a microsoft bug I believe.