File Corruption & Recovery

Fix Excel Creating Zero-Byte and Temporary Files on Network Drives

Maira MehtabMaira Mehtab Nov 4, 2026 869 views

Question details

The user is experiencing an issue where saving an Excel file on a network drive turns the original file into zero bytes and leaves a temporary file.

Fix Excel Creating Zero-Byte and Temporary Files on Network Drives
Product
Microsoft Excel
Device & OS
not provided
Scenario
Saving an Excel workbook to a mapped network drive.
Observed behavior
The original file becomes 0 bytes in size, and a randomly named temporary file remains in the directory instead of being properly renamed.
Before you start

Before troubleshooting, copy your affected Excel workbooks and any remaining temporary files to a local drive to prevent permanent data loss while testing network settings.

Solution 1Recommended

Disable Excel Add-ins to Prevent Save Interference

Faulty or conflicting add-ins can disrupt the saving process on network drives. Disabling them helps identify if they are the root cause.

Excel relies on a specific sequence to save files: it creates a temporary file, deletes the original, and renames the temporary file. Third-party add-ins can sometimes interrupt this sequence, especially over network connections.

1
Open Excel Options

Launch Microsoft Excel and click on 'File' in the top-left corner, then select 'Options' from the bottom of the menu.

2
Access the Add-ins Menu

In the Excel Options window, select 'Add-ins' from the left-hand navigation pane.

3
Manage COM Add-ins

At the bottom of the window, ensure the 'Manage' dropdown is set to 'COM Add-ins' or 'Excel Add-ins' and click the 'Go' button.

4
Disable the Add-ins

Uncheck the boxes next to all active add-ins in the list, then click 'OK'.

5
Restart and Test

Restart Excel and attempt to save a workbook to your mapped network drive to see if the zero-byte issue is resolved.

Disable Excel Add-ins to Prevent Save Interference
Isolate the Problem Add-in: If this resolves the issue, re-enable your add-ins one by one, restarting and testing after each, to identify the specific add-in causing the failure.
Free Microsoft Office alternative

Try WPS Office for Reliable Network File Management

If Microsoft Excel continues to struggle with network drive saves, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling spreadsheets locally and over network shares without the hassle of file corruption.

  1. 1. Download and Install: Download WPS Office from the official website and install it on your computer.
  2. 2. Open Your Network File: Launch WPS Spreadsheets, click 'Menu' > 'Open', and navigate to your mapped network drive to select your spreadsheet.
  3. 3. Edit and Save: Make your edits and click 'Save'. WPS Office's optimized save protocol will update the file reliably on the network share.
Highly compatible with Microsoft Excel formats (.xlsx, .xls) to ensure data integrity.Lightweight design ensures faster saving and minimal network timeouts.Free to use with a familiar user interface, requiring zero learning curve.Robust file-handling capabilities to prevent zero-byte corruption.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel create randomly named temporary files when saving?

When saving a file, Excel first writes the changes to a temporary file (e.g., ~temp.tmp). Once saved successfully, it deletes the original file and renames the temporary file to the original name. If interrupted, the temporary file remains.

Can I recover my data from the zero-byte file?

A zero-byte file contains no data and cannot be recovered directly. However, you can often recover your data by renaming the randomly named temporary file left in the same directory to have an `.xlsx` extension and opening it.

Does my antivirus software affect saving files to a network drive?

Yes. Antivirus programs actively scan new files. If the scan locks the temporary file while Excel is trying to rename it, the save process fails, leaving a zero-byte original and a temporary file behind.

Why does this issue only happen on network drives and not locally?

Network drives introduce latency and rely on server-side permissions and file-locking protocols. If a server momentarily drops the connection or locks the file longer than Excel expects, the sequence fails. Local drives process these commands instantly, avoiding the issue.