Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel creating tmp files

Status
Not open for further replies.

Mijjoiji

IS-IT--Management
May 15, 2001
48
SE
Hi!
I encountered this really confusing problem today. I´ve got a user that are working with a couple of excel documents, the documents are placed in his private folder on his network drive. A week ago he complained about it taking so long time to save the documents and after waiting a couple of minutes he got the message "couldn´t save ....., can´t find the filename specified" (something like that). Today when I was checking the backup logfile I noticed that there was like a couple of thousends of tmp files (16.000 to be exact) and they where all 0 KB of size. I looked it up on the microsoft support site and I think I´m near the sulotion but not even close anyway. When excel is saving a workbook to the network drive it creates a temp file with an eight-character alphanumeric string, it is then supposed to delete that temp file (atleast this is how I´ve figured it). If the user wouldn´t have rights to modify or delete that would occur in a temp file to be created but not deleted (16.000 tmp files in a week, that would mean a lot of saving for this pour fella). In this case this guy has full control over his share and everything is ok. He could save the documents after a while so we didn´t bother to investigate this case anymore. The tempfiles aren´t named with eight character alphanumeric names, in this case they are named "fsaFFD.tmp, fsaFFE.tmp" and so on, some are alphanumeric and some not. I also took the workbook to a folder on my pc (c:\documents) and the same thing happened for me but i "only" got 11.000 tmp files. It´s really confusing me, hope someone can come up with an explenation.

Best regards

/Jim
 
Forgot to mention that the user are running excel 2000 in terminal server envirionment. When I tried to modify the documents and the same problem occured it was in excel 2000 on a win2000 machine.

Best regards
/Jim
 
try saving to a local drive, then moving the file to the network drive, open it, then do a "save".

Same thing happened to me last week, and saving the file to a local HD as "Book1.xls" worked great. Then, we moved Book1.xls to the network drive, renamed it, switched to excel..opened it from there, and re-saved it.

All works fine now...still don't know what caused it though.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top