Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
Q. I have an Excel workbook that contains many tabs. We have a “Total” tab, but the formulas to sum all of those tabs gets very complicated. Plus, new worksheets get added and the formulas have to be ...