Excel 2000 cannot save and create temp file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GK - 25 Oct 2005 18:30 GMT

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.

Reply to this Message

Dave Peterson - 25 Oct 2005 22:33 GMT

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.

> 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
[quoted text clipped - 3 lines]
>
> Thanks in advance.

Signature

Dave Peterson

Reply to this Message