.tmp files not being deleted when closing an Excel file

[JD]

Running Excel 2000, cutting and pasting parts of a
worksheet into a new worksheet. A .tmp file is created,
closed both windows and the .tmp file is still there.

 

[BrianB]

Yes, there must be a bug. It is necessary to clear out .tmp file
occasionally otherwise odd problems occur as the folder gets filled u
with them

 

[Dave Peterson]

I've never seen excel by create .tmp files in any folder except for the windows
temp folder.

Any chance you're in there.

If you are, then I'd recommend not working in there. It's too easy to clean
things up and delete something important.

Any antivirus software running that creates .tmp files???

 

[JD]

Doesn't Excel automatically delete the .tmp file once the
spreadsheet is closed? If it is supposed to, in this
case it is not.

 

[Dave Peterson]

The only .tmp files that I've seen excel create are stored in my Windows Temp
folder.

And it usually (not always) cleans up when you close excel.

Are you storing your workbook in that folder (windows temp)?

If you are, then I'd stop that. I know that I clean that up with no thought
about what should be saved. Then if I do have extra .tmp files there, I just
wipe them out.

 

[JD]

The spreadsheet is located on our network, Excel is
placing a .tmp of the spreadsheet in the same dir as the
doc. Excel usually deletes the .tmp file once the
orginal spreadsheet is closed, in this case it is not,
and will not let you attach it to an E-Mail unless you
delete the .tmp file.

 

[Dave Peterson]

The only .tmp files that I've seen excel make are in that windows temp folder.

When I opened a test workbook, I saw my temp folder get filled with:

C:\WINDOWS\TEMP\~DF2F53.TMP
C:\WINDOWS\TEMP\~DF3038.TMP
C:\WINDOWS\TEMP\~DF338E.TMP
C:\WINDOWS\TEMP\~DF344F.TMP
C:\WINDOWS\TEMP\~DF3452.TMP
C:\WINDOWS\TEMP\~DF34A1.TMP
C:\WINDOWS\TEMP\~DF486B.TMP
C:\WINDOWS\TEMP\C2D1.TMP
C:\WINDOWS\TEMP\C2E2.TMP
C:\WINDOWS\TEMP\mflC314.TMP
C:\WINDOWS\TEMP\VBE


Do your .tmp files have the same kind of names.

Any chance that you have some code creating these (not excel by itself)?

If you close excel, delete the .tmp files, and reopen excel in safe mode:

Windows start button
run
excel /safe

(Safe mode will disable lots of stuff--including macros.)

And then open that workbook, do you still get those temp files?

And when I close excel, it usually (not always) cleans up these .tmp files.
(but it does leave the VBE folder.)