I'm not even that good at Excel. I can't do VBA, I often have to Google things. Nonetheless, on my team I'm the only person of capable of more than a SUM function and so I have to help maintain 3 moderately complex spreadsheets that serve different purposes in the team.
At least every two weeks someone will completely mess one up. I don't even know how - most recently they've undone half of some moderately complex data validation formatting that I was asked to add by the spreadsheet owner. I assume someone came along, thought 'this doesn't look the same as it did before' and instead of using a modicum of common sense to fill out the new options, deleted a large number of cells so that they could input whatever shite they wanted to. I could find out who using the version history, I'm sure, but I don't want to.
I can normally rescue the spreadsheet by restoring a previous version, but it's a disruptive thing that takes me away from whatever task I'm otherwise doing, because I normally suddenly receive a barrage of messages of 'it's not working' and 'can someone assist' in a group chat. I think sometimes it makes me look bad.
I might be able to solve some of the issues by locking/ protecting some cells, but that does come with its own issues. Not least that I'd need to look through each workbook to work out exactly what permissions general users need and what they don't - at least a few hours + testing to make sure there's nothing else people need.
In a previous role we worked 100% from Excel collaborating across lots of worksheets. I'd never before had anyone treat documents with such disregard. I almost definitely won't scream, but AIBU to feel like I need to?