create .tmp files when saving

  • Thread starter Thread starter Collin Camp
  • Start date Start date
C

Collin Camp

Am having a problem with several of my dell machines
running window xp professional and office xp pro.

when users open an excel file, make a change and save it,
then go back in the file, many times it says the file can
be open in read only because the file is in use. it then
creates a copy of the file using the .tmp as an extension.

Why is this happening so frequently.

any help would be appreicated.

collin
 
Hi Collin

Try this first

Reboot first and then
Delete all the files and subfolders in your \Windows\Temp directory (Win95/98/ME),
or your \Documents and Settings\<user>\local settings\temp directory (Win2K/WinXP)

And if this not working

Tools>Options>General uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

On the Windows Taskbar
Close Excel
Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.
 
I tried the tasks that were mentioned below but it did
not work. Again, when opening then saving changes made in
excel, it wants to save the file /name using a .tmp, it
basically tells you the file will be saved as a .tmp file.

this is not the same as files in the \\winnt\temp folder.
this is something related to windows xp professional and
excel 2002. it doesn't seem to happen to word, just excel
docs.

any help would be appreciated.

-----Original Message-----
Hi Collin

Try this first

Reboot first and then
Delete all the files and subfolders in your
Click to expand...
\Windows\Temp directory (Win95/98/ME),
or your \Documents and Settings\<user>\local
Click to expand...
settings\temp directory (Win2K/WinXP)
And if this not working

Tools>Options>General uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

On the Windows Taskbar
Close Excel
Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case
Click to expand...
Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)
 
Back
Top