You can resolve the issue of old Excel temp files appearing when copying folders by manually deleting them from your system’s temporary directories and configuring Google Drive to exclude specific file patterns. These temporary files, often named with a tilde (~) or starting with "AutoRecover," are created by Microsoft Office during editing sessions and do not contain permanent data. By clearing these artifacts and adjusting sync settings, you can ensure that only your primary workbooks are transferred between computers without cluttering your storage.
Understanding Excel Temporary Files
When you open an Excel workbook, the application creates hidden temporary files to protect your work against unexpected crashes or power failures. These files typically have names that begin with a tilde (e.g.,
~$MyDocument.xlsx) or are stored in the AutoRecover folder. They are designed to be transient, meaning they should disappear once the main file is saved and closed properly. However, if Excel does not shut down cleanly—due to a forceful closure, a system crash, or a network interruption during a save operation—these temporary files may remain on your disk.
When you use Google Drive to copy a folder containing active or recently used Excel files, the synchronization engine scans all items within that directory. Since it cannot distinguish between essential documents and leftover temporary artifacts, it uploads everything it finds. This results in the destination computer receiving these useless temp files alongside your actual spreadsheets. Understanding this behavior helps clarify why the problem persists even after you delete the files from one machine; the next sync cycle will simply recreate the issue if the source still holds them.
Why They Persist After Closing
The persistence of these files is usually linked to how Excel manages its recovery cache. Even after you close a workbook, the temporary lock file might linger if the operating system did not grant Excel permission to delete it immediately. In some cases, antivirus software or backup utilities may hold a handle on these files, preventing their removal until the next reboot. Recognizing that these are safe to delete is the first step in managing your storage effectively, as they serve no purpose outside of the active editing session.
Manual Deletion Process
To remove these files from your current computer, you need to access the system’s temporary folders where Excel stores its working data. Follow these steps to clean up the existing clutter:
- Close All Excel Instances: Ensure that no Excel windows are open. Check the taskbar or use Task Manager to confirm that
EXCEL.EXE is not running in the background.
- Navigate to Temp Folders: Press
Windows Key + R to open the Run dialog. Type %temp% and press Enter. This opens the user-specific temporary folder.
- Identify and Delete: Sort the files by name or date. Look for files starting with
~$ followed by your workbook name, or files named AutoRecovery save of.... Select these files and delete them. You may also check the folder path indicated in Excel Options under "Save" for additional AutoRecover files.
- Clear System Temp: Repeat the process for the system-wide temp folder by typing
temp in the Run dialog. Be cautious here and only delete files that you recognize as temporary office documents.
After performing these deletions, restart your computer to ensure any locked handles are released. Once the system is back online, verify that the problematic files are gone before initiating another sync with Google Drive.
Configuring Google Drive Exclusions
Preventing future occurrences requires instructing Google Drive to ignore these specific file types. While Google Drive for Desktop does not offer a simple "exclude by extension" checkbox in the main interface, you can manage this through selective sync or by moving temp files out of the monitored directory.
If your temp files are located within the same folder as your main workbooks, consider changing Excel’s AutoRecover location. Go to
File > Options > Save and change the "AutoRecover file location" to a directory outside your Google Drive synced folder. This ensures that temporary backups are stored locally on your hard drive rather than being synced to the cloud.
Alternatively, if you must keep everything in one folder, you can utilize the exclusion features available in third-party sync tools or create a separate "Archive" folder for completed projects. For standard Google Drive users, the most effective strategy is maintaining a clean workspace. Regularly closing workbooks properly and using the "Save As" function for final versions reduces the likelihood of orphaned temp files accumulating over time.
Impact on Collaboration
Removing these files does not affect your ability to collaborate. Other users accessing the shared spreadsheet via Google Sheets or Excel Online will not see these local temp files. The version history and collaboration features rely on the cloud-stored master file, not the local temporary caches. Therefore, cleaning up your local environment is purely a hygiene practice that improves performance and reduces unnecessary bandwidth usage during sync operations.
For those interested in optimizing their spreadsheet workflows further, understanding how to manage data efficiently is crucial. You might find it helpful to look into
Summarizing max values for each row in an excel table to streamline your data analysis tasks, reducing the complexity of files that generate more temporary data.
Frequently Asked Questions
Can I recover data from an Excel temp file?
Generally, no. These temporary files are partial snapshots intended for crash recovery, not full backups. If you need to recover unsaved work, use Excel’s built-in "Recover Unsaved Workbooks" feature found under File > Info, which accesses the official AutoRecover cache rather than random temp files.
Why do temp files reappear after deletion?
They reappear because any new instance of opening an Excel file triggers the creation of a new temporary lock file. If you leave the file open or if Excel crashes again, the system recreates the artifact. Properly saving and closing the file removes the need for the temp file, stopping the cycle.
Does deleting temp files affect my cloud backup?
No. Deleting local temp files has no impact on your cloud backup status. Your cloud backup relies on the final saved state of your document. In fact, deleting these files frees up space and prevents Google Drive from syncing unnecessary data, making your backups more efficient.
How can I stop Excel from creating so many temp files?
You cannot entirely disable temp file creation as it is a core safety feature. However, you can reduce their footprint by shortening the AutoRecover interval in Excel Options. Setting it to save every 5 minutes instead of 10 ensures smaller, more frequent snapshots that are less likely to cause sync conflicts.
Are these temp files a security risk?
They are not a direct security risk, but they can expose sensitive information if left unattended. Since they contain a snapshot of your data, anyone with access to your computer could potentially view recent edits. It is best practice to delete them regularly, especially on shared or public computers.