When working on an Excel file, Excel creates a .TMP file so you can undo
changes you make if necessary. This is normal. However when you have
finished working with the file and save it, Excel should delete the .TMP file
it created but it doesn't, so you can finish up with dozens of .TMP files
after you've been working for a while.

How do I stop this happening.

Creating .TMP files isn't normal for excel.

Saved from a previous post:

Add some controls to a worksheet from the control toolbox toolbar and you'll see
some .tmp files in the %temp% folder. But I've never seen excel put them in any
other location.

If those .tmp files look like: ...\VB*.tmp

I searched google again for "\vb" and .tmp and got a few hits.

One of them:
http://groups.google.co.uk/group/mic...1eecaad1c774cc
or
http://snipurl.com/1339g

One person posted that they saw files that had names like: ~RF26c83af.TMP.

It was caused by AVG.

You can read her description in this thread:
http://groups.google.co.uk/group/mic...cd4eed0638e395

or
http://snipurl.com/jyus

A while ago, someone posted back that uninstalling something called "Panda
ClientShield" fixed a similar problem.

Even if you're not running "Panda ClientShield", you could try disabling this
program to see if the problem goes away.

hillytheman wrote:

When working on an Excel file, Excel creates a .TMP file so you can undo
changes you make if necessary. This is normal. However when you have
finished working with the file and save it, Excel should delete the .TMP file
it created but it doesn't, so you can finish up with dozens of .TMP files
after you've been working for a while.

How do I stop this happening.

--

Dave Peterson