sharing violation

[M_FLEMING]

I am having problems saving an excel workbook. I keep getting the following
error message, "Your changes could not be saved to 'workbook'.xls because of
a sharing violation. Excel has created a temporary file with your changes
preserved, called 'xxx', You can save the temporary file as a new name or
lose your changes and all futures changes." The only options available are
save temporary file or lose all changes. Any suggestions?

 

[Jan Karel Pieterse]

Hi M,

I am having problems saving an excel workbook. I keep getting the following
error message, "Your changes could not be saved to 'workbook'.xls because of
a sharing violation. Excel has created a temporary file with your changes
preserved, called 'xxx', You can save the temporary file as a new name or
lose your changes and all futures changes." The only options available are
save temporary file or lose all changes. Any suggestions?

Two things come to mind:

1. Anti virus software setting

The anti virus software might still be scanning the temporary file Excel
creates during the saving process when Excel is ready to rename it to its final
name. Try changing your virus settings, especially regarding Office files.

2. Permissions in the folder

If you have read and write but no delete rights, saving with Excel fails
because it cannot remove the old copy of the file.

You are left with the strangely named file and the message you saw in both
cases.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Mick O'Hara]

I'm wrestling with this one as well.
I have found a curious thing about this issue.
I'm dealing with a workbook with macros enabled.
I'm supporting two workers who share an invoicing workbook on a shared
folder inside 2003. This workbook had worked seemlesly for months. On the
same day they both developed this sharing violation/temp file issue.
The workbook is stored on a 2003 server with Excel 2003 on the stations.
I found this
If I go into the macros security settings and click on any security level,
though at this stage during my testing I've set security to low, just by
twidling any radio button, (and I can reset it back to its original security
level of at this stage low), I can then go back and save the updated file.
Kerebros and time sync features appear to be working.
I have completely disabled all features of McAfee enterprise but haven't
fully checked out all permissions yet.
This one came out of the unwarranted blue for the employees. I'm sure its
not their fault.
MS Update? unlikely as this issue has remained unsolved by Microsoft for
years.

url:http://www.ureader.com/msg/10301729.aspx