Fix a Slow-Opening and Saving Excel XLSM Workbook
Question details
Determine why one macro-enabled Excel workbook takes minutes to open or save and grows substantially after Save As.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- A user needs to open and save a corporate XLSM workbook without long delays or excessive file growth.
- Observed behavior
- The workbook opens faster on another laptop but still takes about 1.5 to 2 minutes. Its size increases substantially with each Save As, even after VBA code and sheets are removed.
Note the workbook's file size and how long it takes to open and save. Check whether you can test a local copy and whether your organization restricts Office updates or troubleshooting tools.
Compare a Local Copy on Another Computer
Use this test to distinguish workbook-related delays from issues specific to one computer.
In Excel, open File > Account > Update Options > Update Now. If updates are managed by your organization, ask your administrator to check them.
Restart the computer, open the workbook in Excel, and measure how long opening and saving take.
Copy the workbook to a local folder and test it there. Open the same copy on another computer and compare the opening and saving times.
If the workbook is slow on both computers, investigate its contents or possible corruption. If it is significantly slower on only one computer, ask an administrator to investigate that computer.

Repair or Rebuild the XLSM Workbook
Use this approach if the delay or file growth follows the workbook to another computer.
Ask an Administrator to Check the Affected Computer
Use this option when the workbook performs significantly worse on one computer or troubleshooting requires elevated permissions.
Try WPS Spreadsheets as an Excel Alternative
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and moving between Office formats. It does not repair Microsoft Excel or guarantee that an XLSM workbook's macros will run.

Frequently Asked Questions
Why is my XLSM workbook still slow after I remove VBA code?
The delay may come from other workbook content, corruption, or the computer's background software. Test a local copy on another computer, then inspect formatting, formulas, charts, and data validation.
What should I do if Save As makes the workbook larger?
Compare the file sizes after using File > Save As, inspect unnecessary workbook content, and try File > Open > Browse > Open and Repair. If growth continues, consider rebuilding the workbook in a new XLSM file.
Can I troubleshoot a clean boot without administrator privileges?
A clean boot may require administrative access. Share your test results with your administrator and ask them to perform the test or try another user profile.
Should I disable antivirus software to speed up Excel?
Do not disable company security software yourself. Ask your administrator to investigate scan delays and determine whether a controlled exclusion test complies with company policy.
Will saving as XLSX preserve my workbook's macros?
No. XLSX does not preserve VBA macros. If macros are required, use File > Save As and select Excel Macro-Enabled Workbook (.xlsm), then test the saved file.




