Once a feature has been removed from the ToC, all locks on that data should be removed as close to instant as possible.
This problem plagues those who use Excel spreadsheets in ArcGIS Desktop especially.
You've added your spreadsheet into ArcGIS Deskstop ready to map x and y, you then spot a problem and need to make a change to the spreadsheet. Currently you must remove the spreadsheet and close down the .mxd that the spreadsheet was added to or you'll find your data is locked.
This can also happen to Shapefiles and/or Feature classes.
Removing the burden on the user to sort these locks out would simplify, quicken, and overall improve his/her experience.
I know this is a long standing issue, so apologies if this is a duplicate idea but could not find a similar one.
p.s. imo, The line "Its Microsoft’s fault" doesn't cut it anymore as it doesn't mean anything to your novice GIS user - they just wont use it again.
This still seems to be an issue (I'm on 10.6) and the workaround that @ScottBall suggested doesn't do the trick. I recently changed jobs and at my old job as long as I didn't have the .xls selected after removing it from the TOC and single clicked on another folder or file the lock was broken and I was able to open the file in excel without having to close ArcMap. At my new job, I am having this issue. Both places running windows 10 and Arc 10.6. Is there some kind of configuration/setting somewhere that I am missing??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.