Excel Performance Problems

Fix a Slow-Opening and Saving Excel XLSM Workbook

Olivia MillerOlivia Miller Nov 22, 2026 868 views

Question details

Determine why one macro-enabled Excel workbook takes minutes to open or save and grows substantially after Save As.

Fix a Slow-Opening and Saving Excel XLSM Workbook
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.
Before you start

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.

Solution 1Recommended

Compare a Local Copy on Another Computer

Use this test to distinguish workbook-related delays from issues specific to one computer.

1
Update Excel

In Excel, open File > Account > Update Options > Update Now. If updates are managed by your organization, ask your administrator to check them.

2
Restart and retest

Restart the computer, open the workbook in Excel, and measure how long opening and saving take.

3
Test local copies

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.

4
Interpret the result

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.

Compare a Local Copy on Another Computer
Both factors may contribute: A workbook that is faster on another computer can still have a workbook-related problem if it remains unusually slow there or continues to grow after Save As.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceWork with Microsoft Excel formats such as XLSX and XLSReview spreadsheet content without relying on the affected Excel installationUse a lightweight, free Office suite for everyday documents
microsoft office alternative - wps office

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.