To: Dave Peterson

[V]

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 <[email protected]>
Date: Mon, 07 Nov 2005 07:35:46 -0600
Local: Mon 7 Nov 2005 06:35
Subject: Re: 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 -

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" <[email protected]>
Date: 7 Nov 2005 09:27:26 -0800
Local: Mon 7 Nov 2005 10:27
Subject: Re: 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.

 

[Dave Peterson]

I'm not sure what part you don't understand?

And I don't know what problem you're having.

 

[V]

You don't remember me? Just Kidding!!! I see that you help many

My problem- Excel 2007 creates a new tmp file Every time I "save changes"
after
editing my workbook/sheet. This just started happening a few weeks ago. I
read that 'Wendy' (whom you helped) had the exact problem. Following is her
update/solution. I don't know what the AVG is or what/how to follow the fix.
I am hoping you could explain a bit more detail or the "Explaination for
Excel Dummy" version.
With Appreciation, V


Update: I appear to have fixed the problem. It *was* AVG that was
creating the extra files. I thought I had it disabled but I'd only
disabled one component of it, not the resident scanner which is what
scans all files. I disabled it entirely and the problem disappeared.
Then I started searching to see what could be causing it in the
resident scanner. I tried turning off heuristic scanning, but the
problem remained. The problem was "on close" scanning. Once I turned
that off the problem disappeared. I've used that for a long time and
never had a problem, but they updated this component on 10/23/05 and I
guess it introduced a problem that didn't exist before. My husband had
an older version of the scanner on his PC from March so he didn't have
the problem I was having.

I will write to AVG and inform them of the problem. I appreciate your
patience and help! Hopefully my post here will help others who use AVG
free too.

 

[Dave Peterson]

Glad you found the solution to your problem.

Sometimes, those antivirus programs like AVG can be a little too aggressive.

 

[V]

Dave,
I copied & paste too much info to you.
I don't know what the AVG is?? And HOW DO i USE HER fIX??

 

[Dave Peterson]

AVG is an antivirus program.

The original poster's problem was fixed by turning off one of the features in
AVG. Since I don't use AVG, I'm not sure where it can be found.

If you're running an Antivirus program (like AVG), you may want to mention it.
Maybe someone will have a suggestion on how to tweak a setting in that program.

Dave,
I copied & paste too much info to you.
I don't know what the AVG is?? And HOW DO i USE HER fIX??