Excel Saves to temp file, when saving after a few changes.

[RivaCom]

I have a user who is trying to save a excel file to a network drive.
Full admin rights, and occasionally it will not allow her to save the
file, she can rename it and it will save fine. But if she tries to
overwrite the file, it saves it to a temp file and tells her she can
open the temp file and save that. Which the temp file can not be
opened with excel 03. Anyone else run into this issue? She is using
the Office 03 suite.

 

[Dave Peterson]

Some background...

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.

======
Since she can rename the file manually, and the problem only occurs randomly, it
sounds like there might be a network problem. I think I'd get the IT folks
looking at it.

Does the save work ok from a different pc?
To a different network drive?
From a different location on the network using the same pc (physically move that
pc to test???).

 

[RivaCom]

Some background...

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.

======
Since she can rename the file manually, and the problem only occurs randomly, it
sounds like there might be a network problem. I think I'd get the IT folks
looking at it.

Does the save work ok from a different pc?
To a different network drive?
From a different location on the network using the same pc (physically move that
pc to test???).

Well I know the problem happens to at least two of our users. She
can save it to a different name, but it seems to happen quite often
where she will open it up, edit it, and it will not be able to save
the work she just edited to the same file. We upgraded our switches
to Gbic cards not too long ago, but I would doubt that a faster
connection would be the resulting issue.

 

[Dave Peterson]

I'm not saying that faster is better.

I'm guessing that there could be a physical problem with a network. IIRC,
someone posted that a NIC did cause this kind of trouble, but a longgggggggg
time ago, I saw a desk that was inadvertently placed on a network cable cause
all kinds of trouble.

I have no idea if your network is having trouble, but if you can't isolate it to
anything else, you may want to look there. (I'd start by disabling the AV
(temporarily) to see if that helped. It seems like an easier test to me.)

 

[RivaCom]

I'm not saying that faster is better.

I'm guessing that there could be a physical problem with a network. IIRC,
someone posted that a NIC did cause this kind of trouble, but a longgggggggg
time ago, I saw a desk that was inadvertently placed on a network cable cause
all kinds of trouble.

I have no idea if your network is having trouble, but if you can't isolate it to
anything else, you may want to look there. (I'd start by disabling the AV
(temporarily) to see if that helped. It seems like an easier test to me.)








--

Dave Peterson- Hide quoted text -

- Show quoted text -

Well I guess assuming it's a network issue is the best we can do. We
definately do not want to take down the AV, we have had a company wide
spread of viruses before and we wouldn't like to go down that road
again. Thanks, I'll just have to start trying a different drive
perhaps.

 

[Bruce Sinclair]

Well I know the problem happens to at least two of our users. She
can save it to a different name, but it seems to happen quite often
where she will open it up, edit it, and it will not be able to save
the work she just edited to the same file. We upgraded our switches
to Gbic cards not too long ago, but I would doubt that a faster
connection would be the resulting issue.

Lack of network disk space (or not enough quote allocated) can give some odd
saving errors. Worth checking at least