You just had to get lucky and hope that the document ID that you were looking at contains what you’re looking for,” said Igel ...

Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.