Hi Dave,
I found this older ?/response (Response from you). The ?/problem is exactly
like mine. I don't understand the answer/solution.
Could you please explain to me,
Thank you so much for helping!
V







You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.


5. Dave Peterson View profile Translate to English (UK)Translated
(View Original)
More options 7 Nov 2005, 06:35

Newsgroups: microsoft.public.excel
From: Dave Peterson
Date: Mon, 07 Nov 2005 07:35:46 -0600
Local: Mon 7 Nov 2005 06:35
Subject: Duplicate files open from autorecover
Reply to author | Forward | Print | Individual message | Show original |
Report this message | Find messages by this author
I've never seen excel create a .tmp file (outside the windows temp folder).
So
I still don't think it's excel--do you use that Panda ClientShield software?

And did you test AVG by (temporarily) disabling it to see what happened?


Some background:


When excel saves the file, it saves it as a temporary file with a funny name
(8
characters--no extension).


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.




- Hide quoted text -
- Show quoted text -

Wendy wrote:

Update on the problem: I previously thought that it was autorecover
that was the culprit but that doesn't appear to be the case. I had one
workbook open and noticed that a *.tmp file was created with an older
date (probably the last time I'd saved the file?) the first time I
tried to save a change. Additional *.tmp files were created every time
I manually saved a new change to the file. It doesn't appear that
autorecover is the problem -- manual saves are. I spent some more time
searching through the knowledge base at Microsoft -- still no luck.
These temp files are not in the usual location -- they are in the same
folder in which my original files are located. In a span of 10 minutes
I ended up creating 4 temp files all of the same size as my original
file. Closing Excel didn't remove them so I had to manually delete
them. I do not have any "ghost" copies of Excel open according to the
task manager.



--

Dave Peterson




Reply to author Forward







You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.


6. Wendy View profile Translate to English (UK)Translated (View
Original)
More options 7 Nov 2005, 10:27

Newsgroups: microsoft.public.excel
From: "Wendy"
Date: 7 Nov 2005 09:27:26 -0800
Local: Mon 7 Nov 2005 10:27
Subject: Duplicate files open from autorecover
Reply to author | Forward | Print | Individual message | Show original |
Report this message | Find messages by this author
No, I don't use Panda Client Shield. Yes, I did disable AVG and it
didn't fix the problem. Excel though has always saved a small temporary
file when I open something (my folders are set to show hidden files so
I can see them). Word & PowerPoint do something similar, but not like
Excel has been doing the past few days. The Excel problem is unique
cause it is a full copy of the entire file, not a tiny file only a
couple of K. I understand what you're saying but the problem is that
excel is not deleting the temporary files and is creating new ones
every time I save.

For example, I just made a tiny change to a file and saved it. An
additional temporary file was created with the file name followed by
~RF26c83af.TMP. This file was dated when I last saved the file (last
night). I made a second change and saved again. A new temporary file
was created with the date/time I saved the file last today and the
extension ~RF26dad2b.TMP. It sounds like it is Excel generating these,
not something else. If I exit Excel, the files remain on my computer.
They aren't deleted. In the past, the tiny files created by excel
always disappeared whenever I quit the program.