Stop using fragile direct links—Power Query creates faster, automated, and more robust workbook connections.
If you get the This Workbook contains links to one or more external sources that could be unsafe warning prompt when opening an Excel file, use the below solutions to fix the error: Check external ...
Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.