Hi

I have a shared workbook (it also contains macros) on a network, when one of
the users open it and try to save it, it gives error message.
"Unexpected file lock by user. Please try again...."

However when I save it, its ok before getting the error by other user but if
the other user gets the error and after that I also receive the same error.

Please guide me what is the problem and how can I fix it.
I amd using Excel 2007.