Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
Master non-destructive edits, troubleshoot errors, and document your logic to build resilient, automated Power Query ...