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

This example demonstrates how to replace a summary item with a custom footer template to calculate the total summary dynamically in batch edit mode.