Excel with hyperlink

%3CLINGO-SUB%20id%3D%22lingo-sub-1678107%22%20slang%3D%22en-US%22%3EExcel%20with%20hyperlink%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1678107%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20use%20in%20excel%20(%3DHYPERLINKKI(%24H%241%26amp%3BA51%26amp%3B%24B%241%26amp%3BD51%26amp%3B%24C%241))%20after%20some%20times%20of%20using%20it%20automatically%20stops%20working.%20I%20get%20an%20error%20message.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIf%20I%20change%20parameter%20it%20works%20again.%20Probably%20somebody%20thinks%20that%20i%20am%20a%20robot.%20I%20am%20not.%20I%20am%20just%20a%20fast%20reader%20and%20fast%20data%20searcher%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1678107%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1678251%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20with%20hyperlink%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1678251%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F797273%22%20target%3D%22_blank%22%3E%40PetriN2040%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EWhat%20is%20the%20error%20message%20that%20you%20are%20receiving%3F%3C%2FLI%3E%3CLI%3EWhen%20you%20receive%20an%20error%2C%20is%20the%20hyperlink%20receiving%20an%20error%20a%20valid%20web%20address%3F%3C%2FLI%3E%3CLI%3EExcel%20limits%20a%20cell's%20width%20to%20255%20characters%3B%20is%20the%20hyperlink%20receiving%20an%20error%20within%20the%20255%20character%20limit%3F%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 thinks that i am a robot. I am not. I am just a fast reader and fast data searcher

2 Replies
Highlighted

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?
Highlighted
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.