Fix Excel Taking Too Long to Save VBA-Generated Workbooks
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.

- 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.
Ensure you save a backup copy of your macro-enabled workbook to a local drive before making structural changes or running optimization scripts.
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.
Move or save a copy of the workbook to your local desktop or C: drive to eliminate network drive latency as the cause.
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.
Create a completely new, blank workbook and save it to the same local directory to verify that your system and storage are functioning normally.
Optimize Workbook Contents and Formatting
Reduce file bloat by cleaning up defined names, external links, and excessive conditional formatting that drag down save speeds.
Add Timing Statements to VBA Code
Pinpoint exactly which part of the VBA script is causing the delay by adding timers to your macro.
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. Download WPS Office: Visit the official WPS Office website and download the free installation package.
- 2. Install and Launch: Follow the on-screen instructions to install the suite, then open WPS Spreadsheets.
- 3. Open your file: Click 'Open' and select your macro-enabled workbook to experience faster editing and saving.

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.




