Unanswered

Schedule a flow to open and close an Excel stored in Sharepoint site

(0) Share

Report

Posted on by WorkingRicardo

818

I need an Excel file to open several times a day and also close. This is stored in Sharepoint, not my desktop. (this so the excel file auto updates the data is connected to).

Is it possible to do it with a flow? I just saw today that the Desktop app is much different than the web, and maybe is possible this way but don't know how.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-jefferni on at

Like (0)

Report

Hi @WorkingRicardo ,

If you have office scripts using in this excel file, you can use the following two actions along with a schedule trigger:

Run script

Run script from SharePoint library

Best regards,

Was this reply helpful? Yes No
WorkingRicardo 818 on at

Like (0)

Report

hey @v-jefferni
Oh wow this is complete uncharted territory for me. I have no idea of scripts.
Could you detail a way to set this up so the file opens, stays open for a few mins and closes?

Was this reply helpful? Yes No
BS-04011124-0 2 on at

Like (0)

Report

@WorkingRicardo Hello Ricardo,

I have the same problem. I have a Main Excel Folder that has data sources from Side Excel Folders.

The problem is I have to open those Side Excel Folders to refresh the data has entered by other people while I don't work. So only to refresh the Main Folder I have to open and close several Side Folders.

Could you manage to automate them?

Was this reply helpful? Yes No