Forum Discussion

Copper Contributor

Nov 12, 2021

Xlookup with Hyperlink

I have a database of products and in one of the columns we have hyperlinks to the suppliers PDFs. When making a priceless I want to get this link to the priceless. We use Xlookup for all other da...

excel

Westy-world

Copper Contributor

Mar 21, 2022

Riny_van_Eekelen

When i wrap the formula with =hyperlink(... it hyperlinks to my one drive account instead of the link I assigned it to

TEXASFOREVER1936

Copper Contributor

Aug 09, 2022

ANY LUCK? I HAD THE SAME ISSUE AND EVEN WENT AS FAR AS UNLINKING MY PC FROM ONEDRIVE. NOW I JUST HET A "CANNOT OPEN THE SPECIFIED FILE." ERROR MESSAGE. Westy-world

Patrick2788
Silver Contributor
Aug 09, 2022
TEXASFOREVER1936

Clear this:

Rebuild link and test again. The hyperlinks might've been breaking on save.
- TEXASFOREVER1936
  Copper Contributor
  Aug 09, 2022
  Thank for your response, I have done that as well. No luck there.
  - SergeiBaklan
    Diamond Contributor
    Aug 09, 2022
    TEXASFOREVER1936
    
    Please check this thread https://techcommunity.microsoft.com/t5/excel/hyperlink-w-xlookup-receiving-err-invalid-response-quot-the-site/m-p/3293279 if something helps.