Shared workbook keeps renaming self

[three6ohchris]

we have shared workbooks that can be used by up to 40 employees at an
give time. occasionally the workbooks will magically rename themselve
to things like 78097B00 or 6D8CD100 and when going to properties i
states "type of file: file"
can anything offer any explanation as to what is causing this and ho
to stop it? it has become very troublesome since it takes a while t
fix.

thanks

 

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