Fix Excel Leaving TMP Files After Closing Workbooks
Question details
Users are experiencing an issue where Excel fails to automatically delete temporary files after saving or closing workbooks.

- Product
- Microsoft 365 Excel
- Device & OS
- not provided
- Scenario
- Opening, saving, and closing workbooks on local or network drives.
- Observed behavior
- Excel generates temporary (.tmp) files during the save process but does not remove them when the file is closed, causing drive clutter for multiple users.
Ensure you have full administrative or read/write permissions to the affected local or network directories, and back up your current workbooks before performing any repairs.
Update and Repair Microsoft 365 Apps
Running an online repair and updating to the latest version of Microsoft 365 can fix underlying application bugs that prevent Excel from properly clearing its temporary files.
Microsoft occasionally releases patches that address file saving and temporary file generation bugs. Performing an Online Repair ensures that any corrupted installation files are fully replaced.
Press the Windows key, type 'Control Panel', and select 'Programs and Features' (or 'Add or Remove Programs').
Find 'Microsoft 365' in the list of installed applications, right-click it, and select 'Change'. Choose 'Online Repair' and follow the on-screen prompts to complete the process.
Once the repair is complete, open Excel, go to 'File' > 'Account', click 'Update Options' under Product Information, and select 'Update Now'.
Identify Antivirus or Add-in Conflicts
Third-party background applications, such as antivirus software or Excel add-ins, may lock the temporary files during the save process, preventing Excel from deleting them.
Verify Folder Permissions and Perform a Clean Boot
Inadequate permissions on specific network or local drives, as well as interfering background services, can disrupt Excel's standard file-saving protocols.
Try WPS Office for a Bug-Free Spreadsheet Experience
If Microsoft Excel continues to clutter your local and network drives with undeleted TMP files, consider switching to WPS Office. It provides a stable, lightweight, and completely free alternative that handles your spreadsheets cleanly without leaving persistent temporary files behind.

Frequently Asked Questions
Why does Excel create TMP files when saving a workbook?
Excel creates a temporary file to safely store your data during the saving process. Once the save is successfully completed, Excel normally deletes the original file and renames the temporary file to the original filename to prevent data loss.
Is it safe to manually delete the leftover Excel TMP files?
Yes. As long as the corresponding Excel workbook is completely closed and you have verified that your most recent changes were saved correctly, you can safely delete these leftover TMP files (e.g., D0DD478B.tmp) to free up storage space.
Why does this issue happen more frequently on network drives?
Network drives can introduce latency, restrictive folder permission protocols, or undergo aggressive scanning by network-wide security software. These factors can lock a temporary file mid-save, preventing Excel from successfully issuing the deletion command.
How can IT administrators prevent this issue for multiple users?
IT administrators should ensure that organizational antivirus solutions have proper exclusions for standard Office temporary files on network shares, audit group policies regarding COM add-ins, and deploy the latest Microsoft 365 feature and security updates across all affected endpoints.




