Excel save to network drive issue

[Jo]

I have found several articles out at Microsoft related to
this issue but I am having a very difficult time finding a
solution. Here is the error in full that the user gets:

Your changes could not be saved to
'name of the file', but were saved to a temporary
document named '95430000'. Close the existing document,
then open the temporary
documetn and save it under a new name.

Microsoft articles: 214032, 291070, 291204, 271513

User is saving to a "home directory" that is configured in
his NT profile.

Microsoft states to check the file permissions. This user
has full access rights to the directory. User does not
have any imaging software and the client is running
TrendMicro Office Scan.

This user is running Windows 2000 w/ Office 2000 SR1 with
all the critical patches. I have another user with the
same issue but it is with Word 2000.

Lastly, we seem to be having a problem with our drive
mappings. When we reduce the number of drive mappings for
the user to one, the server shows that there are mulitple
drives mapped. I don't know if this is related to our
Excel and Word saving problem.

 

[Chris Cradic]

Sounds like another user may have the same file open at
the same time. You should get a prompt when you go to
open it though. Is it possible that a Tape Backup job or
maybe a virus scan may have the file open. Are your
files compressed on your server??

 

[Guest]

Nobody else has access to this shared directory except the
Domain Admins. There is nor error or prompt when the user
opens the file just when they try and save it.

I could ask the backup folks about when the backups finish
running, this user does start work at 7am and maybe the
backups are affecting this issue.

I have asked the NT Server Guys to maybe call Trend Micro
and see if they have seen this issue.

Lastly we just moved this user's share to a Windows 2000
server to see if he still has this problem.

 

[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 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.

I think I'd start with the easiest stuff first. Try disabling the antivirus
software.

If that didn't help, I'd go back and have those permissions checked once more.