View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Excel does not delete TMP files on closing. Why?

Are you positive that there is an extension (.tmp) on these files?

If the files really don't have any extension, then maybe something else is going
wrong.

Some background...

When excel (xl2003 and older) saves the file, it saves it as a temporary file
with a funny name (8 characters--no extension) in the same folder.

If the save is successful, xl will delete the original (or rename it to its
backup name (like "backup of book1.xlk)) and if that's successful, xl will
rename the funny named file to the original's name.

Maybe something is going wrong with that last rename step.

If you really do have that .tmp extension, do you run any AV software at all?
If yes, I'd try disabling it to see if the problem goes away.

Saved from a previous post:
==========

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.

===============================
ps. I didn't remember correctly. That thread from Wendy (#7) does indeed point
to AVG as the culprit.

Ben Elliott wrote:

I find that Excel 2003 is not deleteing its tempoary files when it closes. Is
there a problem? How do I get it to do so?


--

Dave Peterson