cancel
Showing results for 
Search instead for 
Did you mean: 

Cloud Script in Excel with Linked Data

I have a flow that runs a script on my excel online to add a formula that links another workbook to this file. However it only updates if I open the file manually instead of just updating on the cloud without opening the file. 

 

Is there a workaround for this, and if not, this would be great for business users and organizations that might want to use this in there flows without having to manually open the file for the content to update.

Status: New
Comments
MGazovic
Regular Visitor

Hi, I had the same problem and couldn't find a way. The alternative is to use Excel scripts to copy the data from one workbook to another, you need two scripts.

 

Expor Range:

 

function main(workbook: ExcelScript.Workbook): string {
  let sheet = workbook.getWorksheet("Hoja1");
  let range = sheet.getRange("A1:D10000");  
  return JSON.stringify(range.getValues());
}
 
Import Range:
 
function main(workbook: ExcelScript.Workbook, values: string) {
  let sheet = workbook.getWorksheet("Hoja1");
  let range = sheet.getRange("A1:D10000");
  range.setValues(JSON.parse(values));
}
 
Then use Power Automate to join them.