Excel's HYPERLINK Function Not Working π
Learn why the HYPERLINK function breaks with the dynamic array engine and how to fix it in Excel.

Andrew Moss
1.7K views β’ May 15, 2025

About this video
The HYPERLINK function has been broken for as long as the dynamic array engine has been around.
Iβll tell you whyβ¦
I tried the exact same example in the Windows, macOS, and web versions of Excel β and got three different results.
ππ«ππ π£ππ
"Apple", "Google", and "Microsoft" are featured in A2:A4 with their corresponding URLs in B2:B4.
To return the hyperlinks as friendly names, forget about using =HYPERLINK(B2:B4,A2:A4), as that repeats the first value for the entire spilled range (e.g. "Apple";"Apple";"Apple").
You really have to go out of your way to correct it:
=
MAP(B2:B4,
A2:A4,
LAMBDA(url,website,HYPERLINK(url,website))
)
However, even then, how this formula performs varies depending on the platform youβre using.
I hovered over each result in A6:A8, and hereβs what happened:
πͺππ‘ππ’πͺπ¦
A tooltip appeared with Appleβs website in it, even for Googleβs and Microsoftβs.
π πππ’π¦
Absolutely nothing. The hyperlinks didn't even work.
πͺππ
Each website name displayed a pop-up containing the correct URL.
Strange, eh?
Excel for the web was the only platform to successfully do what I wanted, but it still has the spill issue the others are affected by, meaning I couldnβt use HYPERLINK on its own.
This isnβt exactly a difficult bug to find. Iβve brought it up a few times since 2023, but nothingβs ever been done about it.
Too busy prioritising Copilot, I guessβ¦
---
Where to find me:
Website β https://andrewmoss.me
LinkedIn β https://www.linkedin.com/in/andrewcharlesmoss
Medium β https://andrewcharlesmoss.medium.com
GitHub β https://github.com/andrewcharlesmoss
Twitter β https://twitter.com/andrew_c_moss
Facebook β https://www.facebook.com/andrewcharlesmoss
Threads β https://www.threads.net/@andrewcharlesmoss
Donations:
PayPal β https://www.paypal.com/donate/?hosted_button_id=39JH3GVDXGKM6
Buy Me a Coffee β https://www.buymeacoffee.com/andrewmoss
Iβll tell you whyβ¦
I tried the exact same example in the Windows, macOS, and web versions of Excel β and got three different results.
ππ«ππ π£ππ
"Apple", "Google", and "Microsoft" are featured in A2:A4 with their corresponding URLs in B2:B4.
To return the hyperlinks as friendly names, forget about using =HYPERLINK(B2:B4,A2:A4), as that repeats the first value for the entire spilled range (e.g. "Apple";"Apple";"Apple").
You really have to go out of your way to correct it:
=
MAP(B2:B4,
A2:A4,
LAMBDA(url,website,HYPERLINK(url,website))
)
However, even then, how this formula performs varies depending on the platform youβre using.
I hovered over each result in A6:A8, and hereβs what happened:
πͺππ‘ππ’πͺπ¦
A tooltip appeared with Appleβs website in it, even for Googleβs and Microsoftβs.
π πππ’π¦
Absolutely nothing. The hyperlinks didn't even work.
πͺππ
Each website name displayed a pop-up containing the correct URL.
Strange, eh?
Excel for the web was the only platform to successfully do what I wanted, but it still has the spill issue the others are affected by, meaning I couldnβt use HYPERLINK on its own.
This isnβt exactly a difficult bug to find. Iβve brought it up a few times since 2023, but nothingβs ever been done about it.
Too busy prioritising Copilot, I guessβ¦
---
Where to find me:
Website β https://andrewmoss.me
LinkedIn β https://www.linkedin.com/in/andrewcharlesmoss
Medium β https://andrewcharlesmoss.medium.com
GitHub β https://github.com/andrewcharlesmoss
Twitter β https://twitter.com/andrew_c_moss
Facebook β https://www.facebook.com/andrewcharlesmoss
Threads β https://www.threads.net/@andrewcharlesmoss
Donations:
PayPal β https://www.paypal.com/donate/?hosted_button_id=39JH3GVDXGKM6
Buy Me a Coffee β https://www.buymeacoffee.com/andrewmoss
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
1.7K
Likes
2
Duration
0:22
Published
May 15, 2025
User Reviews
3.8
(1) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.
Trending Now