Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Joel Pratt
 
Posts: n/a
Default Excel creating temp files upon save.

For some reason, on just a a few of our shared Excel files, when saved by the
client Excel creates a temp file in the directory. It has created somewhere
near 180 of them in the past few days.
Most of the clients are Excel 2003 w/current SP but it doesnt seem to matter
what version they are using.
Any ideas?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

What do those temp file names look like?

If they look like 8 character random letters/numbers, then 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.

Common things that get blamed for interruptions to this process are antivirus
software poking its head in or network errors--either permissions or physical
problems.

Maybe temporarily disabling the antivirus software would be the easier thing to
test. If that doesn't help, maybe there was a permissions change???

===
And if those names don't look like 8 characters, then maybe it's not excel.
Maybe your antivirus program is not cleaning up after itself.



Joel Pratt wrote:

For some reason, on just a a few of our shared Excel files, when saved by the
client Excel creates a temp file in the directory. It has created somewhere
near 180 of them in the past few days.
Most of the clients are Excel 2003 w/current SP but it doesnt seem to matter
what version they are using.
Any ideas?


--

Dave Peterson
  #3   Report Post  
Joel Pratt
 
Posts: n/a
Default

Thanks for the reply.
It is a random eight character file with no extension. For some reason Excel
is not deleting it.
I have rebuild the folder and file structure and it permissions and I will
see how that goes. If that doesnt fix it, I will try disabling the antivirus
and see where that takes me.

Thanks again!

Joel

"Dave Peterson" wrote:

What do those temp file names look like?

If they look like 8 character random letters/numbers, then 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.

Common things that get blamed for interruptions to this process are antivirus
software poking its head in or network errors--either permissions or physical
problems.

Maybe temporarily disabling the antivirus software would be the easier thing to
test. If that doesn't help, maybe there was a permissions change???

===
And if those names don't look like 8 characters, then maybe it's not excel.
Maybe your antivirus program is not cleaning up after itself.



Joel Pratt wrote:

For some reason, on just a a few of our shared Excel files, when saved by the
client Excel creates a temp file in the directory. It has created somewhere
near 180 of them in the past few days.
Most of the clients are Excel 2003 w/current SP but it doesnt seem to matter
what version they are using.
Any ideas?


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing multiple Text files into Excel 2003 JMA Excel Discussion (Misc queries) 5 May 5th 05 09:48 PM
Cannot access read-only documents. tomgillane Excel Discussion (Misc queries) 14 February 7th 05 10:53 PM
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 07:58 PM
Excel Files Won't Open From Shortcut ConfusedNHouston Excel Discussion (Misc queries) 5 December 31st 04 06:25 PM
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen Excel Worksheet Functions 1 November 17th 04 02:39 AM


All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"