I have inherited a problem. A W2k server running AD etc, 10 workstations running XP O/S and also Office XP. The problem lies with Excel file locks not being released from the server. Users can open the Excel spreadsheets and close them BUT the server does not recognise/accept the file closure and therefore retains the file as being open.
I have tried numerous tests of opening and closing, open on one PC close on another PC etc but there is no pattern, the only constant is the fact that the server does not release the file locks, the server still sees the files as in use and this will cause the PCs to lock when they try accessing a closed Excel doc, the server still seeing the doc as open.
The Excel documents were initially created on Office 97, I think, as I said I inherited this problem, I have read elsewhere to check that the PCs are running SP2 for Office XP which I think they are.
If anyone has any suggestions or pointers I would be greatful, from viewing discussions boards this does seem a fairly common problem.
Cheers
I have tried numerous tests of opening and closing, open on one PC close on another PC etc but there is no pattern, the only constant is the fact that the server does not release the file locks, the server still sees the files as in use and this will cause the PCs to lock when they try accessing a closed Excel doc, the server still seeing the doc as open.
The Excel documents were initially created on Office 97, I think, as I said I inherited this problem, I have read elsewhere to check that the PCs are running SP2 for Office XP which I think they are.
If anyone has any suggestions or pointers I would be greatful, from viewing discussions boards this does seem a fairly common problem.
Cheers