PDA

View Full Version : Excel Temp files



Fatcam
02-12-2003, 03:08 PM
Hi there

We have an excel document on our server that we all open from time to time. We are aware that 2 of us cannot open it at once as it will be locked for editing. The problem is that sometimes when somebody makes some changes to the document and then saves, the chances are not made to the original document but saved in a tmp file in the same directory. There are 5 computers on our network and we are all running office XP. The permissions on the server are set to give everyone access also.

cheers

Barnabas
02-12-2003, 03:40 PM
This sounds very strange to me. When an excel file is open there will be a temporary version of the file created in the folder in which the original resides however that file should be deleted when the user closes the Excel file. In the event of an Excel or a system crash those files can remain behind and help you recover lost excel spreadsheets. Is this happening when the document is being closed normally?
Office XP can also come up with a message saying that the document is in use by someone else when it is infact not, usually when saving the document. It then gives you the option to make a copy of the document you are working in or to overwrite the changes. Is this what is happening or is it actually creating .tmp files?

parry
02-12-2003, 04:37 PM
Hi, you can have multiple users use the same workbook. Have a look at this MSKB article (http://support.microsoft.com/?kbid=269860) on how to do this. There are also a couple of links to other articles you should reads as well. I suggest you also read the Excel Help, specifically the topics 'Share a workbook' and 'about shared workbooks'.

In regards to your saving problem it may be to do with a temporary network problem at the time of saving. See this article (http://support.microsoft.com/default.aspx?kbid=291204) here.

If your worried about losing data then go SaveAs and the box that appears to locate a folder and enter a save name has a Tools option in the menu bar. Select Tools|General Option and put a check against the Always Create Backup box before you save the file. You will now have to use the SaveAs version of the workbook to ensure backups are auto created. They are created in the same folder as the file.

You may also want to amend the Auto save option - Tools|Options|Save tab.

hth :-)