View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
samdev samdev is offline
external usenet poster
 
Posts: 15
Default Excel Saving to Temp File for files on network

Dave: Thx - I will have the network person look into this...

Dave Peterson wrote:
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.

======
And if the original is gone, it sounds like you have delete permission, but not
rename permission. I'd try renaming any old file on that share in front of the
IT folks so they could see it happen (and change the permissions????).

And when they get back to you, I'd try renaming any file again manually (via
windows explorer) to see if what they did worked <bg.

samdev wrote:

I'm using Excel 2000 on Win XP.

When I open a file that is located on a network drive, and revise file
and go to save it the file is changed to temp file with a different
name, usually numeric. This temp files replaces the original filename.
It doesn't do this for another other program and also doesn't do it if
I save to the c drive.

The error message reads..."changes could not be saved...but were save
to a temporary document named 08ED9871. Close the existing document,
then open the temporary file and rename it"

When I do this it doesn't allow me to rename...

Any ideas?

thx in advance.


--

Dave Peterson