Answered

Excel Automate: New Script → Error Message

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

In Excel I can't create new or access already existing scripts in the Automate ribbon. After a moment the following error message appears:

// German

"Ein unerwarteter Fehler ist aufgetreten. Schließen Sie den Aufgaben Bereich, um es erneut zu versuchen.
Wir konnten Ihre Skripts nicht laden. Versuchen Sie es erneut."

// English

"An unexpected error occurred. Close the task pane to try again.
We could not load your scripts. Try it again."

How can this problem be solved?

Thank you in advance and best regards,

Daniel

Categories:

General topics

I have the same question (0)

All responses (17)

Answers (2)

Yutao Huang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Anonymous - sorry to hear you were experiencing issue when creating script. Is it still happening now?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@Yutao No, two days later it suddenly worked without me having done anything. Since then the issue never reoccured.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

can help to share how to solve this issue

Was this reply helpful? Yes No
Yutao Huang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Anonymous -
We are aware of intermittent authorization failures that might be causing this. We have been actively looking into it and will update back with more details. Thanks for your patience!

Was this reply helpful? Yes No
delphi 5 on at

Like (0)

Report
Copy link

Link copied!

same issue. Please update status A.S.A.P

Was this reply helpful? Yes No
Verified answer

Yutao Huang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Update: we are still working with our partner teams to track down the issues and possible solutions. Based on the information we have collected so far, we suspect the issue might be related to this admin settings: SharePoint and OneDrive unmanaged device access controls for administrators - SharePoint in Microsoft 365 | Microsoft Learn

If possible, can you folks help to reach out to your SharePoint admins or tenant admins and check if the particular policy (block access from unmanaged devices) mentioned in the above article is turned on or off, or if they are aware of this policy at all?

Thanks again for your patience and support!

Was this reply helpful? Yes No
delphi 5 on at

Like (0)

Report
Copy link

Link copied!

If we turn off block access from unmanaged devices

it looks like solve the issue, however this action will break organization information security policy

which bypass access control, which is unacceptable

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

FYI - although not a good solution, it is A solution. This is why I'll mark it as such.

Was this reply helpful? Yes No
Yutao Huang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi all, please follow this thread for any further updates: Execute Excel Script - Unauthorized - Power Platform Community (microsoft.com). Thank you!

Was this reply helpful? Yes No
ryan666 14 on at

Like (0)

Report
Copy link

Link copied!

Any updates? I just noticed this for the first time today.
Not sure I can afford to just wait/hope that this goes away.
And

And I believe that whatever is going on might be the cause of this Power Automate issue as well:

Was this reply helpful? Yes No