98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » advanced+excel+courses - Save document
advanced+excel+courses - Save document
Resolved · Low Priority · Version Standard
Lan has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course
Save document
every time when I click the "save" botton while I am editing my Excel docuemnt the system creates a TEMP file on my computer. I always have to delete these files after editing the Excel document.
How can I set the system not to show the TEMP files.
Many thanks
RE: save document
Hi Lan,
You should find that when you close your Excel document that the temp file disappears. The file is created for Microsoft Office's 'auto-recovery' system which means if your computer is switched off, or power goes out etc. you can recover the file you were working on.
You shouldn't need to keep deleting the temporary file.
This is true for all MS Office applications if the option is switched on.
Regards, Rich
RE: save document
Thanks Rich, but those temp files never disappears unless i delete them. And they are not hidden.
regards
RE: save document
Hi Lan,
Hmm, that's strange.
What naming format are they given? eg. if your file is called MyWork.xls, what are the temporary file's names? I can use this information to do research more on this issue and get back to you.
Regards, Rich
RE: save document
It doesn't matter what my file called. The temp file ususally with a radom name. e.g. 13A59273.tmp or 44FD41D8.tmp.
so far it only happends to my Excel files.
thanks, Lan
RE: save document
Lan,
Sometimes AntiVirus software can prevent MS Office from deleting it's temp files. If you are running AntiVirus software or a ResidentShield, you could temporarily disable it, open and modify your file (check if .tmp file is created), save and close file, and then see if your .tmp file is removed.
AVG antivirus program discussion on Google Groups.
According to some other sources, Microsoft is supposed to create those .tmp files, but not in the same folder as your file.
"It seems that you have incorrectly set a path for temporary files. Probably you used some tool to change this. The files should be stored in windows temporary folders."
This quote was taken from this forum thread and includes a 'fix' by editing registry keys. But I would be careful using that method and certainly back up your registry and important files before attempting the fix.
Could also be permissions on the folder. Make sure you have full read/write/modify permissions.
Let me know how you get on.
Regards, Rich
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hide separate columns in Excel 2010If you want to hide columns not adjacent to each other for example, Columns A, C and E then:- |