Excel Refresh Data Flow

[HKocyigit]

Hi,

I am quite new on Power Automate and trying to do some things,

My challenge is to create desktop flow so that an excel file refresh data queries then save data in invisible mode.

Thanks your helps,

Best regards, 

[v-litu-msft]

Hi @HKocyigit,

Here is a tutorial on how to operate Excel table in power automate desktop, you could refer to it firstly:

(548) How to use Excel in Power Automate Desktop - YouTube

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HKocyigit]

Hi @v-litu-msft,

Thanks for this video, but it cannot 100% help my case. it is useful for many things on excel.

I could be more specific;

I tried to use desktop recorder to click "Refresh All" then close excel command, the issues are 1- Close excel command does not wait for finalising refresh queries, just save and close the file (I will create flow for 30 different excel reports, each reports refresh time is different, I cannot find the solution for waiting until end of the refresh process...) 2- Using desktop recording excel has to run visible, I want everything will be done invisible...