Excel automations cover auto-updating charts, deadline flags, and smart links; Ctrl+T table charts expand as new rows appear.
Within Power Automate, it has been possible to run scripts in Excel using the Run Script action. Did you know that there is a Run Scripts from SharePoint library action too? Office scripts are similar ...
Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.