Forum Discussion
Preventing TMP files from remaining on external drives
After the Excel update back in the fall of 2021(?), a temporary file (tmp) was created and remained on any external drive to which I saved the Excel file. This NEVER happened before that update. No...
In Excel File → Options → Save, uncheck Create backup file when saving, or use a VBA script to automatically clean up after closing:
Private Sub Workbook_BeforeClose()
Kill ThisWorkbook.Path & \~$.tmp
End Sub