Unanswered

Is it possible to refresh all queries and connecters in an excel sheet using power automate?

Like (0) Share

Report

Posted on 9 Nov 2023 14:57:51 by NickH4

Hi,
I am trying to refresh all queries and connecters (Keyboard Shortcut: Ctrl + Alt+ F5) in an excel sheet using a power automate flow using the browser/cloud version. I have tried looking for a prebuilt flow but could not find anything. I also tried creating a script in excel which runs the command (it worked in excel) but when called from Power Automate does not run. Appreciate any help/advice.

Thanks

All responses (3)

Answers (0)

NickH4 4 on 09 Nov 2023 at 15:54:54

Like (0)

Report

Re: Is it possible to refresh all queries and connecters in an excel sheet using power automate?

No error. It runs fine but doesn't do the refresh. I tested other simple commands to make sure that I am calling the script correctly and they work. For some reason the refresh will not run when called from Power Automate.
NickH4 4 on 09 Nov 2023 at 15:54:35

Like (0)

Report

Re: Is it possible to refresh all queries and connecters in an excel sheet using power automate?

No error. It runs fine but doesn't do the refresh. I tested other simple commands to make sure that I am calling the script correctly and they work. For some reason the refresh will not run when called from Power Automate.
abouchaalaBAIT 930 Moderator on 09 Nov 2023 at 15:01:12

Like (0)

Report

Re: Is it possible to refresh all queries and connecters in an excel sheet using power automate?

Office script is a good option, are you getting an error when calling it from PA ?