'Document not saved'

[Gary_Butts]

Ok, here is the situation. I created a template that has about 1
sheets in it, about 1 mb in size, and it contains buttons and a comb
box as well. Occasionally a user will try to save and get a 'Documen
not saved' dialog and it will not save. When we close it and repeat th
same steps it works fine and all is good. Now, however we have a use
who gets this everytime. We have looked all over the net and tried th
following:
-Checked his disk space, tons left.
-Cleared out all his temp directories as excel dumps lots in thes
(even doc and settings\local settings\temp)
-reinstalled, and service packed.
-Note, we are saving to a local disk and not a network one.

So my question is whether or not anyone else has encountered this, an
if so, what was the solution if any

 

[Dave Peterson]

When excel saves the file, it saves it as a temporary file with a funny name.

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.

I think I'd start with the easiest stuff first. Try disabling the antivirus
software. If that didn't help, I'd yell at my IT/Network guys and see if it's a
permission problem (maybe do that first???).

If it's a hardware problem, yech!!! and Good luck.

 

[CLR]

Hear, hear to everything Dave said.........our network at work is so crummy
that I have this experience frequently............however, if you are only
trying to save to a local drive, then maybe it's caused by some
"housekeeping" program running while you have the Excel file
open...........I'd try to open the file and right away save it.......if that
was successful, then probably the interruption comes with the file being
open over a period of time, like disk maint stuff, or something like
that...........this stuff might could be turned off................my only
defense at work was to save virtually every row of data I entered, and when
it didn't save, I only lost one row..........bummer, but it got me through
the tough time..........

Vaya con Dios,
Chuck, CABGx3