How to save refreshed data in existing excel file saved on SharePoint site?

Question

How to save refreshed data in existing excel file saved on SharePoint site?

Sumeet Kumar Tamta 0

Need help to know how we can autosave refreshed data in an existing excel file if it's saved on SharePoint site.

I am working on a project for sharing an excel file (which is saved on SharePoint site) in which I am pulling data from another source. I want to schedule daily data refresh for this excel file with Power Automate Cloud Flow. I wrote scripts in excel file to Refresh All data and save excel file but seems SharePoint is not recognizing 'workbook.save()' function in that excel file. How can make sure that function work in SharePoint excel file and same script can be run under Power Automate Cloud Flow

workbook.save();

1 answer

Your answer

Answer 1

Phoebe-N 7,110 Microsoft External Staff Moderator

Hi @Sumeet Kumar Tamta

Good day! Welcome to Q&A forum!

I understand you're working on a project to automatically refresh and save an Excel file on SharePoint using Power Automate Cloud Flow, but you're finding that workbook.save() within your Excel script isn't working as expected.

To help you get this working, I need to understand a bit more about your current setup, please answer the following questions:

Please share the full VBA code you are currently using in your Excel file to 'Refresh All data' and attempt to save? (Please include all lines, not just workbook.save())
Could you describe the specific steps and actions you are using within your Power Automate Cloud Flow? Specifically, are you using an 'Excel Online (Business)' connector, and if so, what specific action are you trying to use to interact with your Excel file?
What kind of 'another source' are you pulling data from into this Excel file (e.g., a SharePoint List, a SQL database, another Excel file, a web page)? Also, is this data pulled in using Power Query within Excel, or is it an older type of data connection?

In the meantime, please read this article Refresh an external data connection in Excel - Microsoft Support and Run Office Scripts with Power Automate - Office Scripts | Microsoft Learn to check for any possible core reasons and solutions.

Looking forward to your updates.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Sumeet Kumar Tamta 0 Reputation points

2025-07-28T09:23:05.8333333+00:00
Thanks for your response. In my excel file, I am using below 2 scripts -

Script Refresh All
function main(workbook: ExcelScript.Workbook) { workbook.refreshAllDataConnections(); }

Script Save file
function main(workbook: ExcelScript.Workbook) { setTimeout(() => { // Save the workbook workbook.save(); }); }
I am using these scripts in my Power Automate Cloud flow. Attaching screenshot of Cloud flow below for quick reference- Script "Refresh All" is referenced in 'Run script' action of Cloud flow and script "Save file" is referenced in 'Run script 1' action of Cloud flow. Excel file which we are considering is save at SharePoint location. And yes, this excel file sourcing data from Salesforce instance via Power Query. Let me know if this information works.
Phoebe-N 7,110 Reputation points Microsoft External Staff Moderator

2025-07-28T12:13:19.1766667+00:00

Hi @Sumeet Kumar Tamta

Thank you for the detailed updates.

As a possible solution for your specific issue, it's recommended that you should Modify Your Office Script in Excel and Simplify Your Power Automate Cloud Flow. However, providing in-depth support for this particular issue falls outside the scope of our current resources, I highly recommend posting your question on the Microsoft Power Automate Community Forum, where experts in these areas actively provide support on advanced matter related to Power Automate flow.

My apologies for redirecting you to another forum because I'm afraid that I couldn't assist you thoroughly regarding your issue and looking for an answer in a more appropriate forum would be more time-saving and ideal for you.

Thank you for your understanding and patience.
Sumeet Kumar Tamta 0 Reputation points

2025-07-29T05:44:18.91+00:00

Thanks for sharing links.
Phoebe-N 7,110 Reputation points Microsoft External Staff Moderator

2025-07-29T07:27:23.3666667+00:00

Hi @Sumeet Kumar Tamta

Thank you for your understanding and patience.

Have a nice day!

Share via

How to save refreshed data in existing excel file saved on SharePoint site?

1 answer

Your answer