Unexpected file lock error on shared workbook

[Starguy]

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.

 

[Starguy]

My problem is fixed.
Infact I put that shared file in a folder on network which was not
accessable to all users with full features and rights (like cut, copy, paste,
edit etc). Now I have asked administrator to make a new folder which would be
accessable to all users of that file with full features and rights.

Thanks to all who read and tried to assist me.

 

[Karen Shepard]

I am having the same problem you described, how did you fix it?

A Womand Told Me
http://www.awomantoldme.com

 

[Karen Shepard]

I am having the same problem you described, how did you fix it?

A Womand Told Me
http://www.awomantoldme.com