I used to have that problem a lot when I worked for a smaller company that
had numerous service interruptions on it's network every day. Excel loses
it's way home when that happens if you have a file open from the network.
I got to where I had to save almost after every entry.......an alternative is
to bring the file down to your local C drive and use it there and then put it
back when you're finished, but that's a bit of a pain.
hth
Vaya con Dios,
Chuck, CABGx3
"exg" wrote:
> I'm looking for an answer, but I was wondering if this message was
> ever solved?
>
> I have one user with Windows XP and Office 97. He'll be working away
> on some Excel sheet which is usually big (not huge) and with macros.
> He'll go to save, and gets the message "Document not saved" Nothing
> else, just that message.
>
> If he tries doing a Save As to either a different name or location
> (network or local), it does the same thing; it's just faster with the
> message on the local drive. He has to copy sheet by sheet to another
> workbook and save that one.
>
> Like I say, I've looked around, but no answer.
>
> Thanks for any help.
>
> Ed
>
>
|