Excel Performance Problems

Fix Excel Leaving TMP Files After Closing Workbooks

Camila MilosovichCamila Milosovich Oct 28, 2026 872 views

Question details

Users are experiencing an issue where Excel fails to automatically delete temporary files after saving or closing workbooks.

How to Fix Excel Leaving TMP Files After 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.
Before you start

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.

Solution 1Recommended

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.

1
Open Control Panel

Press the Windows key, type 'Control Panel', and select 'Programs and Features' (or 'Add or Remove Programs').

2
Initiate Online Repair

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.

3
Update Excel

Once the repair is complete, open Excel, go to 'File' > 'Account', click 'Update Options' under Product Information, and select 'Update Now'.

Restart Required: Reboot your computer after the repair and update process to ensure all changes take effect before testing Excel again.
Free Microsoft Office alternative

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.

100% compatible with Microsoft Excel file formats (.xlsx, .xls, .csv)Reliable file saving mechanism that prevents local and network drive clutterLightweight installation that avoids heavy background conflictsFree to use with a familiar, easy-to-navigate tabbed interface
microsoft office alternative - wps office

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.