'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix "The script cannot be saved" Error in Excel Macros and Scripts
Question details
The user is unable to save a recorded macro or script in Excel due to a system error.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Recording a macro or Office Script to automate spreadsheet tasks.
- Observed behavior
- Excel displays the error message "Something went wrong. The script cannot be saved" and fails to store the newly recorded script or macro.
Before troubleshooting, confirm whether you are recording a traditional VBA Macro or a modern cloud-based Office Script, as the permissions and file requirements differ significantly between the two.
Verify Workbook Format and Organizational Policies
Ensure your file format supports macros and that your Microsoft 365 administrator allows script execution.
Office Scripts and VBA macros require specific file types and tenant-level permissions to function correctly. If your organization restricts cloud automation, saving scripts will fail.
Go to File > Save As and ensure the "Save as type" dropdown is set to Excel Macro-Enabled Workbook (*.xlsm) if you are working with traditional VBA macros.
If you are using a corporate or school account, contact your IT administrator to confirm that "Office Scripts" is enabled for your user account within the Microsoft 365 Admin Center.
If you are using Excel on the web, ensure that your browser allows third-party cookies for Microsoft domains, as blocking them can prevent Office Scripts from authenticating and saving.
Resolve Automation Errors via Microsoft Communities
For complex Microsoft 365 configuration and Power Automate sync issues, consult Microsoft's dedicated automation communities.
Experience seamless spreadsheet management with WPS Office
Tired of complicated Microsoft 365 configurations, cloud syncing issues, and script saving errors? Switch to WPS Office, a fast, lightweight, and highly compatible alternative that offers a familiar interface and reliable tools for all your daily spreadsheet tasks.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Open your existing spreadsheets: Launch WPS Spreadsheet and open your existing Excel workbooks. WPS will automatically recognize and preserve your data, formulas, and formatting.
- 3. Access developer tools: Navigate to the Developer tab to effortlessly manage and execute your local macros without relying on complex cloud script settings.
Frequently Asked Questions
What is the difference between VBA macros and Office Scripts?
VBA (Visual Basic for Applications) is a traditional, local scripting language used in desktop versions of Office. Office Scripts are modern, cloud-based TypeScript macros used in Microsoft 365 and Excel on the web, designed to work seamlessly with Power Automate.
Why does Excel say my macro cannot be saved?
This typically occurs if the workbook is not saved in a macro-enabled format (.xlsm), if your organization's IT policies restrict scripting, or if there is a synchronization error with Microsoft's cloud services when using Office Scripts.
How do I enable Office Scripts in Microsoft 365?
Office Scripts must be enabled by a tenant administrator. They can do this by logging into the Microsoft 365 Admin Center, navigating to Settings > Org settings, and toggling the Office Scripts feature on for the organization or specific groups.
