Excel creating random file names when saveing.

[Jon Osborn]

Not quite sure if this is the correct group. But we ae using Excel 2003. I
have created some simple excel files and they work fiine. I copied them out
to the network, the useser started using them and they worked fine except
each time they click save it saves the file and creates a random file like:
7D26D100
7FB5D100
0428D000
A4AA5000
and so forth. I can go in and delete files and everthing still works fine.
I can rename the random file to *.xls and it opens as and Excel file. If I
copy the orginal file to the desktop the random file name is not created
when I save.

Any Ideas?

Thanks,

 

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

=========
It sounds like you have the correct permissions--but that user doesn't.

I'd have that person use notepad to create, delete, and rename a simple text
file on that share. If something bad happens, it's time to go back to your IT
folks and tell them your results.

Users will have to have rename, delete and create/allocate permission.

 

[Bernard Liengme]

To Add to Dave's answer: you are not saving to a floppy are you?

 

[Jon Osborn]

It was a permissions error on the network share. I did not allow modfiy
rights,
Things are fine now.

THanks,
Jon

To Add to Dave's answer: you are not saving to a floppy are you?