Something is happening that isn't good.

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

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.

If you're seeing that funny named file, then something is going wrong.

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.

JsGuero wrote:

Just as my subject suggests, instead of asking me if I want to replace the
original file when saving, excel is simply creating a file with a duplicate
name, with a serialized number. It is really confusing because if I make a
change to an incoming document (received numerous times a day) and
subsequently save it to my pre-existing folder established specifically for
that document, then go back to reference said document, there are numerous
copies, all with different content, none with a complete data set.
How do I get excel to prompt to overwright?

--

Dave Peterson