Re: TMP File Created in Addition to Document Saved
From: Dave Peterson (ec35720_at_msn.com)
Date: 02/25/04
- Next message: Dave Peterson: "Re: Formatting a 19 Digit Budget Code"
- Previous message: Dave Peterson: "Re: Setting Cell Color within a Cell"
- In reply to: steve: "Re: TMP File Created in Addition to Document Saved"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Feb 2004 19:23:28 -0600
Make sure you read that whole thread. Mike A's post wasn't quite right.
http://google.com/groups?threadm=022901c3dc85%2466ffd830%24a501280a%40phx.gbl
(and you have a response to your original post.)
steve wrote:
>
> Should these files be saved in windows temp folder automaticly??
> My system has been doing just fine until Friday! Now the .tmp files are
> saved in "My Documents", How do I change it ??
>
> Steve
>
> ----- Mike A wrote: -----
>
> When Excel saves a file, it actually saves it under a different name,
> closes the current file, copies the saved (temporary) file to the
> original file name, and re-opens the file. (ever wonder why it
> sometimes takes a long time to save a workbook?) If the file cannot
> be re-opened, you usually get an error message saying not enough
> memory to re-open file, close excel and re-open the file, blah blah...
> This will cause the temporary files to remain in the directory you are
> working from.
>
> I have found one cause of this problem is network errors and timeouts.
> It could be related to server traffic, a bad network card, driver
> settings, a bad cable, a router or switch, a wireless bridge, etc.
>
> Have fun finding this one!!
>
> I spent three hours searching and finally found that a switch had a
> bad plug; the resulting errors were producing as many as 250 re-sends
> per packet for one machine. Plugging the network cable into another
> connector (on the same switch) solved the problem.
>
> This caused the problem you described, but only with Excel. All other
> applications just had really long save and load times.
>
> A quick fix, if all you want to do is remove the .tmp files, would be
> to set up a scheduled task on the computer to go into the user's
> Novell directory every night (or hour, whatever) and delete /q *.tmp
> files.
> Mike Argy
> Custom Office Solutions
> and Windows/UNIX applications
>
> Please post on-topic responses to the newsgroup
>
> To e-mail me, remove nospam from the address in the headers
>
-- Dave Peterson ec35720@msn.com
- Next message: Dave Peterson: "Re: Formatting a 19 Digit Budget Code"
- Previous message: Dave Peterson: "Re: Setting Cell Color within a Cell"
- In reply to: steve: "Re: TMP File Created in Addition to Document Saved"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|