Today I had a client who was unable to edit an Excel file and when I checked the security settings and permissions she was listed as an Administrator and all looked good
The file said it had not been in use for weeks and the user said no one was using the file so it should not be locked
To finally resolve this issue I went to the server - Start Menu - Administrative Tools and opened up Share and Storage Management
On the right hand side there is an option for Manage Open Files
this was where I searched for the excel file name she told me and found it open by another user
on the right hand side of that screen showing the file there is an option to close the file
once I did that everything was good to go
No comments:
Post a Comment