Guest Blogger: Dustin Yonker
It has come to our attention of a potentially new issue where users receive one or multiple error messages during the save process of Excel files with macros. All reported cases have been .xlsm file extensions and the errors mention a “sharing violation.” If you are being impacted by this, we are noticing that some of these are involving the Anti-Virus with a focus on the scanning process.
As a test or temporary work-around, adding the .xlsm extension to the excluded list for scanning or disabling the real-time scanning has been a potential work-around until more information is found. Download the latest AV definitions and if that doesn't work, reach out to your AV provider to see if they have an update.
The following are the error messages we have seen thus far:
“Your changes could not be saved to ‘filename.xlsm’ because of a sharing violation. Try saving to a different file.”
“When saving a file, a sharing violation can be caused by the way an antivirus application interacts with Microsoft Office. Check with your antivirus provider to make sure that the current version of the application including updates, is installed. The antivirus provider might also have information or solutions for sharing violation issues.”
“The file format and extension of ‘filename/filename’ don’t match. The file could be corrupted or unsafe. Unless you trust its source, don’t open it. Do you want to open it anyway?”
We will update this blog as more information becomes available on this topic but wanted to give an early heads up to help.