sharing violation error

[Guest]

Hi all, I keep getting a really annoying error message when working with
macro-enabled files in excel 2007. If my files contain macros or custom
functions, saving the file often fails and I get "your changes could not be
saved to (filename) because of a sharing violation". Excel then offers to
save to a temporary file, but when I try to open the temporary file, excel
complains it is corrupt and cannot be opened. I would be SO glad for any
fixes to this annoying problem. Thanks in advance!

 

[Guest]

I'm having the same problem. Delays me a lot.
Need a fix urgently.

 

[Carol Ann]

Me too! It started a couple of weeks ago and I have not been able to save any
modifications since. The help button tells me that I do not have the modify
or delete permissions for the location I am saving to. I do not understand
this and would value some help.

 

[Neil Stevenson]

You have probably sorted this out by now but if not see my comment to Pavan's
question above.

 

[Carol Ann]

Hi Neil
sorry, I can't find the comment you mention can you repeat it for me please?
No, I haven't sorted this out yet so would still like some help. Many thanks.

 

[Neil Stevenson]

Hello Carol
I had 'sharing violation' coming up hundreds of times when I changed to
Vista with Excel 2007 and was trying to update a rather long program. I found
by adjusting my Bullguard antivirus, all sharing violations disappeared. The
virus checker was inspecting all programs as they were opened, even when I
was not connected to the internet. I clicked on "Scan only files with these
extensions....". There is a long list given by Bullguard which does not
include xls or xlsm. This made the difference.
There is another possibility which was to put these extensions into "Scan
exceptions" but I would have needed all the extensions that Excel uses during
the Convert process and was unable to get this to work.
I would suggest that you see if similar exceptions can be used with your
antivirus or antispam checkers.
Neil

 

[Ken Peck]

I didn't have this problem with Vista, but I sure have ever since switching
to W7 Ultimate 64 bit. Is it really a good idea to turn off antivirus
scanning of Excel files? They can contain malicious macros.

I don't use Bullguard. My anti-virus is Trend.