question

Joe-9881 avatar image
0 Votes"
Joe-9881 asked 01406189 published

Unable to run a script via Power Automate when trying to use refreshAllLinksToLinkedWorkbooks Method in Web Excel

Issue: I am trying to implement refreshAllLinksToLinkedWorkbooks() method in a script and using Power Automate to run the script I am having the following error

Error

 {
   "message": "We were unable to run the script. Please try again.\nOffice JS error: Line 3: Workbook refreshAllLinksToLinkedWorkbooks: The operation failed because the user has not granted permission to refresh external workbook links.\r\nclientRequestId: 89dc046d-e456-4a68-9af6-bc9f529dcf6c",
   "logs": []
 }

The script I have for Excel

 function main(workbook: ExcelScript.Workbook) {
  // Refresh all workbooklinks
  workbook.refreshAllLinksToLinkedWorkbooks();
 }

I believe it is related to Web Excel does not have the feature to Enable All Data Types and it keep showing the below notification when I open the Web Excel Spreadsheet

176163-image.png

Where as my Desktop PC have the below settings and no pop-up error

176115-image.png



This looks like a bug. Could Microsoft Dev team advise please?


not-supported
image.png (21.2 KiB)
image.png (44.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered

Power automate is not currently supported here on Q&A. The product group for Power automate actively monitors questions in dedicated forums here.
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

--please don't forget to upvote and Accept as answer if the reply is helpful--


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joe-9881 avatar image
0 Votes"
Joe-9881 answered 01406189 published

Anyone can help? I'm not getting any answers from Power-Automate Community. This seems to be a Web Excel issue!

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Joe, did you ever solve this? Running into the same issue.

Cheers,
David

0 Votes 0 ·