Trouble Saving

[Dave Peterson]

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.

 

[Libby]

Hi

There is an Excel spreadsheet that is kept on a network drive. It was
orginally created in Excel 2000 but is saved by users using Excel 2003. Most
people experience no problems, but I have this problem when I save it:

Every time I save it a new file is created in the folder where the
spreadsheet is kept. This file appears to be a copy of the spreadsheet, but
it has a Windows logo icon and a seemingly random alpha-numeric file name
such as ABDF2003
There are macros in this spreadsheet that save it at certain stages and this
results in a large number of these strange files being generated.

I only get these files when saving to the folder on the network. Saving
elsewhere doesn't produce these files.

Does anyone know why this is happening and how to stop it?

Many thanks in advance.

Libby x