Excel Temp Files Accumulating and Not Deleting: How to Clean Up .tmp Files

You may find your computer’s storage filling up with Excel temporary files that do not delete themselves. These .tmp files are created by Excel to protect your data during editing but can remain after a crash or improper shutdown. This article explains why these files persist and provides clear steps to remove them safely. You will learn how to clean up the temporary file directories and prevent future accumulation.

Why Excel Creates and Sometimes Keeps Temporary Files

Excel generates temporary files with a .tmp extension as a normal part of its operation. Their primary purpose is data safety. When you open a workbook, Excel often creates a temporary copy. This copy acts as a backup in case the program closes unexpectedly, helping to recover your work. These files are typically stored in a designated system folder and are meant to be deleted automatically when you close Excel properly.

The problem occurs when Excel does not close cleanly. A system crash, a power loss, or forcing Excel to close via Task Manager can interrupt the cleanup process. The temporary file is orphaned because the program that created it is no longer running to issue the delete command. Over time, these files can accumulate, consuming significant disk space. They are usually safe to delete manually, but only when Excel is not running.

Locations Where Excel Temp Files Are Stored

Excel uses two main locations for its temporary files. The first is the system-wide Windows Temp folder. The path is often C:\Users\[YourUsername]\AppData\Local\Temp. Files here are from all applications, not just Excel. The second location is specific to Office’s AutoRecover feature. You can find this path within Excel under File > Options > Save > AutoRecover file location. This folder holds draft copies of files you were editing when Excel closed unexpectedly.

Steps to Find and Delete Accumulated .tmp Files

Follow these methods to clean up temporary files. Ensure all Office applications, especially Excel, are completely closed before you begin.

1. Use Windows Disk Cleanup
   Press the Windows key, type “Disk Cleanup,” and select the tool. Choose your main drive (usually C:). The tool will scan. In the list of files to delete, check the box for “Temporary files.” You can also check “Temporary Internet Files” and “Recycle Bin” for a broader cleanup. Click OK and then Delete Files to proceed. This is the safest system method.
2. Manually Clear the Temp Folder
   Close Excel. Press Windows key + R to open the Run dialog. Type %temp% and press Enter. This opens your user-specific Temp folder. You can select all files (Ctrl + A) and delete them (Delete key). Windows may warn that some files are in use; skip those. For a more thorough clean, also open the system Temp folder by typing C:\Windows\Temp in the Run dialog. You may need administrator permissions to delete files here.
3. Clean the Office AutoRecover Cache
   Open Excel. Go to File > Options > Save. Copy the file path listed in “AutoRecover file location.” Close Excel. Open File Explorer, paste the path into the address bar, and press Enter. This folder contains .asd and .tmp files. Select all files and delete them. These are only recovery drafts; your original saved files remain untouched.

If Temporary Files Keep Reappearing or Won’t Delete

Excel or Another Program Is Still Using the File

If you cannot delete a .tmp file, Excel or another process likely has it open. First, ensure Excel is fully closed. Open Task Manager (Ctrl + Shift + Esc), go to the Processes tab, and look for any instance of EXCEL.EXE. If found, select it and click End Task. Then try deleting the file again. If it still won’t delete, restart your computer to clear all file locks and try immediately after startup.

Temporary Files Are Being Created in a Custom Folder

Sometimes, temporary files appear in the same folder as your workbook. This can happen if you are working from a network drive or a folder with restrictive permissions. Excel creates local .tmp files there for speed. To manage this, try moving the workbook to a local folder like Documents before editing. After saving and closing Excel, check the folder for leftover .tmp files and delete them.

Manual Cleanup vs. Automated Tools: Key Differences

Item	Manual Deletion	Windows Disk Cleanup
Control	Full control over which specific files are removed	Removes broad categories of files automatically
Safety	Risk of accidentally deleting a file in use if Excel is open	Very safe; the tool skips files currently used by the system
Speed	Fast for targeting known folders	Slower due to system scan but more comprehensive
Space Recovered	Can recover large amounts if many files accumulated	Often recovers less space but includes other system junk

You now have several methods to remove leftover Excel temporary files and free up disk space. Regularly using the Windows Disk Cleanup tool can prevent most accumulation. For persistent issues, check the AutoRecover folder and ensure Excel closes properly. An advanced tip is to set a shorter AutoRecover save interval in File > Options > Save to minimize potential data loss, which also affects how often temporary drafts are created.