“Document not saved”: Troubleshooting permission and disk space issues.

The alert "Document not saved" or "Document not completely saved" is one of Excel’s most disruptive warnings. It appears during the file-writing process and halts execution before your latest modifications are committed to the drive. Unlike specific syntax or calculation errors, this is an environmental failure: Excel attempted to write your data to storage, but the operating system, disk controller, or security layer rejected the operation.

Quick Answer

Do not close Excel. Immediately click File > Save As, browse to a completely different physical drive (such as a local C:\ directory or desktop folder), and save the file under a new name. This secures your current work before you troubleshoot the underlying permissions or storage limits in the original location.

---

Why the Error Happens: The Three-Stage Save Process

To diagnose why a save fails, you must understand how Excel writes files. To prevent file corruption in case of a crash during saving, Excel does not write directly over your existing file. It uses a three-stage atomic save procedure:

[Stage 1: Create Temp]   Excel writes data to a temporary file (e.g., 4A2B9C00.tmp).
          ↓
[Stage 2: Delete Master] Excel deletes the original file (e.g., Report.xlsx).
          ↓
[Stage 3: Final Rename]  Excel renames 4A2B9C00.tmp to Report.xlsx.

If anything interrupts this three-step pipeline, the save fails:

• If Stage 1 fails: You receive “Document not saved” (no changes written).
• If Stage 2 fails: You receive “Document not completely saved” (your original file remains, and a .tmp file sits in your directory).
• If Stage 3 fails: Your original file is gone, but your updated data exists safely inside a random .tmp file.

---

Step 1: Secure Your Unsaved Work

Never exit Excel when this prompt appears. If you close the program, any work completed since your last successful save is lost.

1. Press F12 to open the Save As dialog box.
2. Select a destination outside the current directory structure. Choose your local Desktop, a dedicated folder like C:\Temp\, or a USB thumb drive.
3. Assign a distinct filename (e.g., Workbook_Emergency_Backup.xlsx).
4. If regular workbook saving fails, change the Save as type dropdown to Excel Binary Workbook (*.xlsb), which processes faster and requires less memory overhead during stream serialization.

If you are locked out from saving entirely due to read-only constraints, consult Recovering data from “Read-Only” files that refuse to save as a new copy.

---

Step 2: Diagnose Disk Space and Quota Restrictions

Insufficient disk space blocks Stage 1 of the save process.

1. Check Primary Drive Storage

1. Open File Explorer and click This PC.
2. Check the free space bar on your primary storage drive (C:\) as well as the destination drive (if saving to an external or mapped drive).
3. If the destination drive has less than a few hundred megabytes free, Excel cannot build the temporary swap file.

2. Check User Storage Quotas

In corporate network environments, network drives (e.g., H:\, S:\) often enforce user quotas. Even if the server itself has terabytes of free space, your specific user account may have exceeded its allocated limit.

• Right-click the mapped drive in File Explorer, select Properties, and check the Quota tab. If your quota is exhausted, you cannot save new data until you delete older files or request an increase.

3. Clear the Windows %TEMP% Directory

Excel uses the local Windows temporary directory to construct swap files during calculation and save routines:

1. Press Windows Key + R, type %temp%, and press Enter.
2. Press Ctrl + A and hit Delete to clear abandoned cache files.
3. Empty your Recycle Bin and re-attempt the save.

---

Step 3: Fix Folder and File Permissions

If disk space is sufficient, permissions are the next suspect. Because Excel must create, delete, and rename files during a single save operation, standard Write permission is not enough. You must have Modify permissions.

Checking NTFS Permissions (Windows)

1. Open File Explorer and navigate to the folder containing your workbook.
2. Right-click the folder and select Properties.
3. Go to the Security tab and click your username or group under Group or user names.
4. Review the Permissions for Users box below:

Permission	Required State	Impact if Missing
Read & execute	Allowed	Cannot open the workbook
Write	Allowed	Fails Stage 1 (.tmp file cannot be created)
Modify	Allowed	Fails Stage 2 & 3 (Original cannot be replaced or renamed)

If Modify is unchecked, contact your system administrator or check the box (if you have local administrative rights) and click Apply.

---

Step 4: Address Antivirus and Sync Engine Conflicts

If your storage space and permissions are correct, third-party software may be intercepting Excel’s three-stage save pipeline.

• Antivirus File Locks: When Excel creates the temporary file in Stage 1, an antivirus real-time scanner may immediately lock that .tmp file to scan it for threats. When Excel attempts Stage 3 (renaming the .tmp file), Windows blocks it because the antivirus has an open handle. Configure your security software to exclude the native Office temporary extension .tmp from aggressive real-time file-locking routines.
• Cloud Backup Conflicts: Services like Dropbox, Box, or local network backup agents that poll folders continuously can seize temporary files during Stage 2. Temporarily pause folder syncing to see if the save completes normally.

If the file refuses to save because Excel encounters damaged structures or formula errors during compile, proceed to Fixing “Errors were detected while saving ‘X’. Microsoft Excel may be able to save the file…”.