Had a look in the historical posts on file locks etc but, found no solution to this little problem. A spreadsheet is shared on our Server 2003, we use Excel 2002 on XP workstations. The spreadsheet contains two worksheets and the Share Workbook settings, the following settings are checked:
'Allow changes by more than one user...'
'Don't keep change history'
'Auto Save every 15mins' with 'Save my changes and see others' changes'
'Ask me which changes win'
After many days of happy saving.. . yesterday, the file locked and no one (4 users had opened it) could save the spreadsheet. An error appeared with:
This file is locked. Try the command again later.
I can't figure what could have caused this, the article below on MS didn't help either:
I could not find a solution and we had to save and started afresh by copying data into a new spreadsheet and setting configuration as above. Naturally, I would like to avoid this in the future and/or be able to rescue the problem without having to start afresh, any ideas would be more than welcome to avoid this in the future? Many many thanks.. .