Sharing violation error with excel 2007 macro-enabled files

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!

I realize this is an old post, but wanted to see if there was every any follow up; I am seeing this issue and it is greatly impacting my productivity. Would be very interested in understanding what is going on and how to address it.