Saving Workbook in 'All Users'; 'Desktop'

[Guest]

I've save a workbook that all users need to keep updated
in the above location. Seems to work OK except that every
time the workbook is saved, a new copy with the 'File
Type' of 'File' is also saved to this location. The
filename is system generated and opens in Excel.

Does anyone have any idea why this happens and/or how to
prevent it.

Thanks.

 

[Dave Peterson]

When excel saves the file, it saves it as a temporary file with a funny name (8
characters--no extension). (Since it doesn't have an extension, you'll see
"file of type: File".)

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.

Maybe you could disable the AV software first. Then see if that helps. If it
doesn't, maybe the users don't have the correct permissions to change the "all
users" desktop.

good luck,