Excel 2003 shared workbook locking issue
Posted on 2007-07-24
I am having an issue with Excel 2003 files shared over a network. The problem is only occurring with one user- all other users are OK. The error is this:
"File is locked. In order to save changes to the file, you can either close the file before making any changes and then re-open it, use Save As (file menu) to save the file using another filename, or turn off shared workbooks and then save the file."
This is error is happening on all files in one particular folder- this folder is on a NAS device. I have made sure no one else has the file open. I have rebooted the NAS device. I have disconnected the mapped drive. I have rebooted the user's PC. These are shared workbooks- there should not be a locking issue as far as I know. Please advise-