Excel 2000 cannot save and create temp file

[Guest]

When I try to save a excel spreadsheet with multiple worksheet, I sometimes
cannot save or overwrite the same filename and then excel just save it to a
temp file with arbitiary filename. This have been happening to more than a
few workstations in my network. They could try to save in locally or in the
network drive but the problem still happened.

Thanks in advance.

 

[Dave Peterson]

When excel saves the file, it saves it as a temporary file with a funny name (8
characters--no extension).

If the save is successful, xl will delete the original (or rename it to its
backup name (like "backup of book1.xlk)) and if that's successful, xl will
rename the funny named file to the original's name.

Common things that get blamed for interruptions to this process are antivirus
software poking its head in or network errors--either permissions or physical
problems.

Maybe temporarily disabling the antivirus software would be the easier thing to
test.