Unanswered

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

(0) Share

Report

Posted on 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

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
NickH4 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
NickH4 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No