How to Troubleshoot HYPERLINK and Dynamic Array Issues in Excel
Question details
Users need to resolve an issue where combining the HYPERLINK function with dynamic arrays fails to correctly update link locations and friendly names.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Generating clickable links dynamically by nesting dynamic array expressions inside the HYPERLINK function.
- Observed behavior
- The link location and friendly name do not update or spill as expected, with behavior varying depending on the Excel version and formula construction.
Ensure your Excel application is updated to the latest version, as dynamic array behaviors and related bug fixes are continuously rolled out in newer Microsoft 365 updates.
Test the Formula and Report the Issue to Microsoft
Since this is often a known limitation or defect in specific Excel versions, reproducing the bug in a sample file and reporting it is the best path to a permanent fix.
The HYPERLINK function sometimes struggles to process dynamic array spills correctly natively. Creating an isolated environment helps determine if the issue is a software defect.
Isolate your HYPERLINK and dynamic array formula in a new, blank workbook to verify the behavior without any external data dependencies or complex formatting.
With your sample workbook open, navigate to the 'Help' tab on the Excel ribbon, click on 'Feedback', and select 'Report an issue'.
Describe the problem clearly and check the option to upload your sample workbook so the Microsoft engineering team can reproduce and prioritize the fix.

Apply Formula Workarounds
Use alternative methods to generate your hyperlinks if dynamic arrays are not fully supported in your current Excel build.
Try WPS Office for Seamless Spreadsheet Management
If you are frustrated by formula limitations or unexpected software bugs in Excel, try WPS Spreadsheet. It offers a free, lightweight, and highly compatible alternative with a familiar user interface that supports advanced formulas and everyday data analysis.

Frequently Asked Questions
Why is the HYPERLINK friendly name not updating in my dynamic array?
In some versions of Excel, the HYPERLINK function does not fully support dynamic array spilling. This causes the friendly name or link location to remain static instead of evaluating dynamically for each row in the spilled range.
Are dynamic arrays supported in all versions of Excel?
No, dynamic arrays are only available in Microsoft 365 subscriptions and Excel 2021 or newer. Older versions, such as Excel 2019 and earlier, do not natively support dynamic array formulas.
Is there a workaround for the HYPERLINK dynamic array issue?
A common workaround is to separate the dynamic array calculation from the HYPERLINK function. Let the array spill in a helper column, then point a standard HYPERLINK formula to the spilled cells and drag it down.




