Replace Excel with something else? First look at these three signs
Anyone searching for how to replace Excel with another system has usually just seen something go wrong. A quote with an old price, an order that can no longer be found anywhere, a colleague off sick while he is the only one who understands the file. It feels like a sudden failure, but it is the end of a long, quiet process.
Let's set one thing straight first: Excel is not bad. It is quick, everyone can use it and you can put anything in it. That is why almost every business starts with it. With ten people it works fine, too. There is one list, one person who keeps it up to date and everyone knows where the file is. Nobody has to think about versions or permissions, because there is only one version and one owner. As long as it stays that way, there is no reason at all to change anything.
But your business grows, and Excel grows with it. Just not in the right way. More people start working in it. Copies appear. Someone saves their own version because they want to do some calculations in peace, someone else adds a few tabs. Before you know it you have a file called "final version 3", and nobody knows which one is the right one any more. Meanwhile the formulas become more complicated, until only one colleague really understands how the whole thing works.
That is Harrie, the company's go-to fixer. Everyone goes to him when a figure doesn't add up. As long as Harrie is around, nothing seems wrong. The work carries on, customers get their goods and the figures are roughly right. And that is exactly why nobody notices that over the past few years the business has come to lean more and more on one file and one head.
A list stores, but does not steer
The most important point is almost always missed. An Excel list stores information, but it does not steer the work. It does not say who has to do what. It does not alert anyone when a job has been sitting for three days. It does not show that an order is stuck in purchasing. That takes people who keep an eye on everything, and those people do it on top of their own work.
In a team of ten you don't notice. In a team of thirty there are suddenly three or four people spending part of their week chasing things up, asking around and comparing lists. Nobody calls that a problem, because it is simply how things work. It happens gradually, and that is why for years it feels as if everything is going fine.
So an Excel problem is almost never an Excel problem. It is a sign that your process no longer sits in a system, but is spread across separate files and in someone's head. Anyone who wants to replace Excel with something else therefore has to look first at which process is actually hidden in that file. A new package that only takes over the list solves nothing. You want something that actually moves the work forward: whose turn it is, what is stuck, what has to go out today.
The three signs that it is already going wrong
That does not mean you should throw away all your Excel lists. A small list for yourself, to keep track of your own planning or to work out a quote, works fine and will keep doing so. It only becomes a risk when three things are true at the same time. The file supports an important process, such as orders, prices or planning. Several people have to work in it. And in practice it runs on one person. One of those three is no cause for concern. All three at once is.
If you recognise all three, it will not suddenly go wrong. It has already been going wrong for a while, and is just waiting for the moment you notice. That moment usually comes on a bad day: Harrie falls ill or leaves, someone works in an old version, a wrong price goes to a customer, or an order falls between two lists. The problem had existed for months. It only just became visible.
Where it breaks in practice
If you look at the moments when things go wrong, you keep seeing the same four breaking points. They are useful for checking your own files against before you decide what to do.
Four breaking points to watch for
The first is the version: more than one file with the same name and slightly different figures. The second is the person: one colleague without whom nobody dares to touch a formula. The third is the silence: work that sits without anyone getting an alert, because a list does not raise an alarm. The fourth is the handover: the moment a job has to move from one list to another, from sales to planning for example. That is where orders fall through, because nobody is responsible for the gap in between.
For your most important file, count how many of those four you recognise. With one, tidying up is often enough: agree on one version, have the formulas explained to a second colleague. With three or four, your process no longer sits in your file but around it, in emails, messages and memory. Then there is little point in adding another tab. Then it is time to capture the process itself in a system that steers the work, so it no longer depends on who happens to be in the office.
Replacing Excel with another package is rarely the first step. The first step is to look honestly at which process sits in your files, who keeps it running and what happens if that person is away for a month. If you recognise the three signs, the question is no longer whether it goes wrong, but when you notice. Lead Innovation helps business owners bring that process to the surface and put it in a system that keeps track of the work itself, so you don't have to wait until Harrie falls ill.