Fix Excel Creating Zero-Byte and Temporary Files on Network Drives
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.

- 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 troubleshooting, copy your affected Excel workbooks and any remaining temporary files to a local drive to prevent permanent data loss while testing network settings.
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.
Launch Microsoft Excel and click on 'File' in the top-left corner, then select 'Options' from the bottom of the menu.
In the Excel Options window, select 'Add-ins' from the left-hand navigation pane.
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.
Uncheck the boxes next to all active add-ins in the list, then click 'OK'.
Restart Excel and attempt to save a workbook to your mapped network drive to see if the zero-byte issue is resolved.

Verify Network Share Permissions and File Locking Settings
Insufficient permissions or aggressive antivirus file-locking can prevent Excel from completing the network save process.
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. Download and Install: Download WPS Office from the official website and install it on your computer.
- 2. Open Your Network File: Launch WPS Spreadsheets, click 'Menu' > 'Open', and navigate to your mapped network drive to select your spreadsheet.
- 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.

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.




