Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
Stop using fragile direct links—Power Query creates faster, automated, and more robust workbook connections.