Excel 2k3: Workbook on network drive, when save creates new file
 

When we open up a shared workbook and enter data into it. Everything works
fine but once you save it the original still contains the information but in
the folder on the network drive that the original is located a new file is
created. This new file is the same size as the original document. It didn't
start doing this until it was moved from our old 2000 Server to our new 2k3
server. Can anyone help?

Does that newly created workbook have a name of 8 characters (with no
extension)?

If yes...

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.

So maybe it's an Antivirus problem (can you disable it temporarily to check) or
maybe it's a network problem (talk to your IT folks.)

AVCCTech wrote:

When we open up a shared workbook and enter data into it. Everything works
fine but once you save it the original still contains the information but in
the folder on the network drive that the original is located a new file is
created. This new file is the same size as the original document. It didn't
start doing this until it was moved from our old 2000 Server to our new 2k3
server. Can anyone help?

--

Dave Peterson