How do I know whether to repair my spreadsheet or replace it with a proper system?

Repair it when the file is simple, low-risk, and used by a small number of people. Replace it when it controls important work, needs permissions or history, has many users, or keeps breaking as volume grows.