When PAD launches Excel, it doesn't do extra steps, such as auto-refreshing links or data. You need to do scripting to do that, such as VBscript or PowerShell.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
