How do you handle version control when multiple people touch the same Excel file?

My team has a shared Excel file on SharePoint that three of us need to update throughout the week. Nothing crazy, just sales forecasts and pipeline data. The problem is we keep overwriting each other's changes accidentally. One person opens it, forgets to close, someone else saves over their work. We tried naming conventions like v2 and v3 but that got messy fast. I know co-authoring exists but sometimes people just don't refresh or they open the desktop version while someone is in the browser. What systems or workflows actually work for keeping things straight without a dedicated data person? Curious if others have found a simple method that doesn't require everyone becoming an Excel expert.