Unanswered

Refresh Excel Application, Copy data and past in online excel

(0) Share

Report

Posted on by JacksonDas

Hello Members,

I was trying to build a flow that can run every 15 minutes where, I want to refresh the Excel application (Desktop) Copy the data from desktop Excel, and paste it on another Excel that is available on SharePoint.

Flow would be like this > Schedule 15 Mins > Open Desktop Excel Refresh it, Copy data (Such as Name, Status, and ID) > Paste this data on the Excel available on SharePoint (under one folder)

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

@JacksonDas

This is more of a Power Automate Desktop solution, to do what you want.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
str8_6 25 on at

Like (1)

Report

Perhaps you can explain why the local excel file can't be a separate Sharepoint file also? It would simplify things if both excel files were on Sharepoint. You wouldn't even need Power Automate at that point because you could import the table in one excel into a different. Whenever File A is updated, the data auto refreshes in File B. You could also control when it refreshes within Excel itself (i.e. when file is opened, every X minutes, etc).

Was this reply helpful? Yes No
JacksonDas 45 on at

Like (0)

Report

Hello Mike, thanks for reverting! Can you help me with desktop flow? I have access to Could and Desktop and will attache both the flow

Was this reply helpful? Yes No
JacksonDas 45 on at

Like (0)

Report

@FLMike, Could you please help me with this flow on PAD, I see comments from str8_6, however I have one while which is full of macro hence unable to move on the sharepoint.

Was this reply helpful? Yes No