Fix “We Were Unable to Load Your Scripts” in Excel or Microsoft 365
Question details
The user needs to resolve the “We Were Unable to Load Your Scripts” error in Excel or Microsoft 365, typically caused by SharePoint or OneDrive access-control policies such as unmanaged-device restrictions.
- Product
- Microsoft 365 / Excel
- Device & OS
- not provided
- Scenario
- The user is trying to load scripts in Excel or Microsoft 365 and receives an unexpected script-loading error.
- Observed behavior
- The application displays “We Were Unable to Load Your Scripts” instead of loading the script, often because SharePoint or OneDrive access policies block the user, device, or location.
Verify that you have Microsoft 365 administrator access or can contact an administrator, and identify the SharePoint or OneDrive site that hosts the scripts you are trying to load.
Review and update SharePoint and OneDrive unmanaged-device access policies
Use this solution when the error is caused by administrator access-control policies that block unmanaged devices from running scripts.
SharePoint and OneDrive unmanaged-device access controls can block script execution for devices that are not enrolled in your organization. Changing the policy to allow access can restore script loading, but it may also reduce access restrictions for other unmanaged devices.
Sign in to the Microsoft 365 admin center, then go to Admin centers > SharePoint.
Select Policies > Access control in the left navigation.
Under Unmanaged devices, review the current setting. If it is set to Block access, choose Allow full access or Allow limited web-only access depending on your organization’s policy.
Make sure the affected user, device, and location are not restricted by additional conditional access rules.
Return to Excel or Microsoft 365 and try loading the scripts again.
Create a targeted conditional access exception
Use this solution when you cannot broadly change the unmanaged-device policy and need to allow only a specific user, device, or location to run scripts.
Switch to WPS Office for lightweight spreadsheet editing without Microsoft 365 script access issues
If Microsoft 365 script loading remains blocked by SharePoint or OneDrive access policies, WPS Office offers a free, lightweight alternative for everyday Excel-compatible work. It supports .xlsx, .xls, and .csv files, keeps a familiar ribbon interface, and lets you open and edit spreadsheets without the same cloud access-control dependencies.
- 1. Download WPS Office: Click Download WPS Office Free from the official WPS website and install it on your device.
- 2. Open your Excel file: Launch WPS Office, go to Home or click Open, and select the .xlsx or .xls file you need to edit.
- 3. Work with familiar tools: Use WPS Spreadsheets to edit formulas, format cells, and save the file back to an Excel-compatible format.

Frequently Asked Questions
Does this error mean my Excel installation is corrupted?
Usually not. It is often caused by SharePoint or OneDrive unmanaged-device access policies in Microsoft 365, so check access-control settings before repairing Office.
Where do I find the unmanaged-device access control?
In the Microsoft 365 admin center, open SharePoint admin center > Policies > Access control, then look under Unmanaged devices.
Do I need administrator access to fix this?
Yes. You need Microsoft 365 administrator access to review and update SharePoint/OneDrive access-control policies or conditional access rules; otherwise contact your administrator.
Can WPS Office run Microsoft 365 scripts?
WPS Office is not designed to run Microsoft 365 Office Scripts. If you need script-specific automation, use Microsoft 365 with the correct access policy. For regular Excel-compatible spreadsheet work, WPS Office is a free alternative.
Will allowing unmanaged devices affect security?
It can reduce restrictions for unmanaged devices. Consider allowing only limited web access, or create a conditional access exception for specific users or devices instead of opening access broadly.




