Excel Performance Problems

Fix Excel Taking Too Long to Save VBA-Generated Workbooks

Khadija KhanKhadija Khan Oct 21, 2026 870 views

Question details

Users experience an issue where Excel takes an excessively long time, sometimes up to 20 minutes, to save a workbook that has been generated or modified by VBA macros.

How to Fix Excel Taking 20 Minutes to Save a VBA-Generated Workbook
Product
Microsoft Excel
Device & OS
not provided
Scenario
Saving a complex, macro-enabled, or VBA-generated workbook.
Observed behavior
The saving process freezes or takes dramatically longer than expected, despite the file size not always being excessively large.
Before you start

Ensure you save a backup copy of your macro-enabled workbook to a local drive before making structural changes or running optimization scripts.

Solution 1Recommended

Isolate the Issue and Test Locally

Determine if the slow saving is caused by network latency or background events by disabling macros and saving to a local disk.

Network storage locations, active antivirus scans, and background VBA events can significantly interfere with the saving process of large Excel files.

1
Save to a local drive

Move or save a copy of the workbook to your local desktop or C: drive to eliminate network drive latency as the cause.

2
Disable application events

Open the VBA Editor (Alt + F11), open the Immediate Window (Ctrl + G), type 'Application.EnableEvents = False', and press Enter to stop events from triggering during the save.

3
Compare with a blank workbook

Create a completely new, blank workbook and save it to the same local directory to verify that your system and storage are functioning normally.

Remember to Re-enable Events: After testing, be sure to type 'Application.EnableEvents = True' in the Immediate Window to restore normal macro functionality.
Free Microsoft Office alternative

Try WPS Office for Fast and Efficient Spreadsheet Management

If your Excel application continues to struggle with saving complex workbooks, WPS Office offers a lightweight, high-performance alternative. It is designed to handle heavy data processing smoothly and requires less system resources, minimizing crashes and freezing.

  1. 1. Download WPS Office: Visit the official WPS Office website and download the free installation package.
  2. 2. Install and Launch: Follow the on-screen instructions to install the suite, then open WPS Spreadsheets.
  3. 3. Open your file: Click 'Open' and select your macro-enabled workbook to experience faster editing and saving.
Highly compatible with Microsoft Excel formats, including .xlsx, .xls, and .xlsmLightweight architecture ensures faster application loading and file saving timesFamiliar user interface requires no learning curve to get startedFree to download and use for your essential spreadsheet and data analysis tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does a relatively small (e.g., 30 MB) Excel file take 20 minutes to save?

File size doesn't always reflect file complexity. A small file can take a long time to save if it contains complex volatile formulas, thousands of hidden objects, excessive conditional formatting applied to entire columns, or broken external links.

Can network drives cause slow Excel saving?

Yes. Saving large or complex macro-generated files directly to a network drive, SharePoint, or heavily synced cloud folder can cause severe delays. Testing by saving the file to your local C: drive can help isolate network latency issues.

How do volatile formulas affect Excel saving times?

Volatile formulas (like TODAY, NOW, INDIRECT, OFFSET) recalculate every time any change is made or before the file saves. If your workbook contains thousands of these formulas, Excel will freeze during saving while it recalculates all of them.

What should I do if my VBA workbook still won't save quickly after optimization?

If standard troubleshooting fails, the file might be corrupted. Try copying the raw data and macros into a brand new workbook. If you are an enterprise user, you may need your IT admin to open a support request with Microsoft to investigate deeper file structure corruption.