sharing violation

[Guest]

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