Sharing violation

[Jan Karel Pieterse]

Hi,

This may have a root cause in your virus scanner settings:

Excel has a funny saving process:

1 Saves to a temporary file
2 If OK, deletes the original
3 Renames Temp file to filename of original.

If in stage 2 or 3 of this process the virus software
starts scanning the TEMP file, XL's process gets
interrupted and you get the file not saved message.

So try changing the settings of the virus scanner.

Regards,

Jan Karel Pieterse
Excel TA/MVP

>-----Original Message-----
>When I am in Excel work sheets and I have accessed a
>sheet for the second or more times in the one boot
>session i find that when I want to exit and save I get
>the message
>"Your changes could not be saved to 'filename.xls'
>because of a sharing violation. Excel has created a
>temporary file with your chages (sic) preserved,
>called 'newalphanumericfilename'. You can save the
>temporary file as a new name or lose your changes and all
>future changes." [Save temporarty file] [Lose all
>changes]
>This happens with my own files on my own machine when i
>create and change the file with my own logon name or with
>shared files on our office network.
>Can anyone advise me why this is happeneing.
>.
>