Thanks for posting problem & solution. I have had the same issue. Microsoft
please fix!
--
Elliot


"MikeKC" wrote:

I found the problem. It was my realtime virus scanner. I stopped the
realtime virus scan and that resolved my problems. As long as my realtime
virus scan is not running then I am able to save my xlsm files without any
problems.

"MikeKC" wrote:

I recently started getting a "sharing violation" error when trying to save
xlsm (macro-enabled) Excel spreadsheets. The spreadsheet is not shared and
resides on my local drive. Now I can't save my spreadsheet anymore. I
Googled this issue and found that others have had the same problem. But I
didn't find a solution. Does anyone know how to resolve this?

I am on Office 2007 and Windows Vista and I have the latest Service Packs
installed for both.